Oracle Applications R12.2.x| Exadata | OCI|Oracle GRC|ECC: May 2024

Quick Tit Bits:

select inst_id,sid,serial# from gv$session

alter system kill session 'sid,serial,@inst_id' IMMEDIATE;

SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||''' IMMEDIATE;' FROM v$session where username like '%S%';

Stale Stats:

set linesize 200

--set heading off

set pagesize 200

break on owner

select distinct owner,table_name object_name,'TABLE' object_type, partition_name,stale_stats,LAST_ANALYZED

from all_tab_statistics

where STALE_STATS='YES'

AND stattype_locked is null

and owner in ('APPLSYS','GL','AP','AR','PO','PA','FV','FA','HR','UFMS','DOCVIEW','XLA','XXLAAPPS','MARKVIEW')

and table_name not like 'BIN%'

order by owner;

select distinct owner,index_name object_name,'INDEX' object_type, partition_name,stale_stats,LAST_ANALYZED

from all_ind_statistics

where STALE_STATS='YES'

AND stattype_locked is null

and owner in ('APPLSYS','GL','AP','AR','PO','PA','FV','FA','HR','UFMS','DOCVIEW','XLA','XXLAAPPS','MARKVIEW')

and index_name not like 'BIN%'

and index_name not in ('MVCN_ELM_UNPARSED_VALUE_NTI','MVCN_ELM_SUGGESTED_VALUE_NTI','MVCN_ELM_IMPORTED_VALUE_NTI','MVCN_SMG_MESSAGE_ATTRIBUTEI')

order by owner;

cd $FMW_HOME/utils/bsu

./bsu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -view -status=applied

dbcli describe-component

dbcli list-jobs

oci db patch list by-database --database-id $DB_OCID --profile DEV --all

$ oci work-requests work-request list -c $COMP_OCID --profile DEV

opatch lsinv | grep -i applied

cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

/dRAM1o/fmw/product/12214/wlserver/server/lib

[oracle@lufRAMfgrcdl011 lib]$ java -cp weblogic.jar weblogic.version

java -cp weblogic.jar weblogic.version -verbose

Middle Tier:

[oracle@luframfebstl011 ~]$ $COMMON_TOP/util/jdk64/bin/java -d64 -version

java version "1.7.0_391"