Concurrent Manager Recovery Wizard – Oracle Applications Manager Troubleshooting and Diagnostics Follow the below steps to use the Concurrent Manager Recovery Wizard: 1. To access the Concurrent Manager Recovery Wizard, use…
Read MoreGOAL: To clear BNE cache in EBS environment Solution: To Clear BNE cache: A. Releases prior to 12.2.7 Using System Administrator responsibility: Login to the application as a user with…
Read MoreCREATE OR REPLACE TRIGGER “123456_TMP_LOGONTRIG” AFTER LOGON ON DATABASE begin if ora_login_user = ‘123456’ then execute immediate ‘Alter session set events ”10046 trace name context forever, level 12”’; execute immediate…
Read Moreselect owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2)||’MB’ “TOTAL_SIZE”, round((num_rows*avg_row_len /1024/1024),2)||’Mb’ “ACTUAL_SIZE”, round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),2) ||’MB’ “FRAGMENTED_SPACE” from dba_tables where owner in(‘a’,’b’,’c’,’d’) and round(((blocks*8/1024)-(num_rows*avg_row_len/1024/1024)),2) > 1000 order by 8 desc; select table_name,round((blocks*8),2) “size (mb)” , round((num_rows*avg_row_len/1024),2) “actual_data (mb)”,…
Read Moreselect table_name,round((blocks*8),2) “size (mb)” , round((num_rows*avg_row_len/1024),2) “actual_data (mb)”, (round((blocks*8),2) – round((num_rows*avg_row_len/1024),2)) “wasted_space (mb)” from dba_tables where (round((blocks*8),2) > round((num_rows*avg_row_len/1024),2)) and owner=’&a’ order by 4 desc; set lines 170 set pages…
Read MoreUsing HPROF: You can use HPROF: Heap and CPU Profiling Agent. A complete dump of the current live objects in the heap can be obtained with: -java -agentlib:hprof=heap=dump,format=b -jar application…
Read MoreHere is the below statement. alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile
Read MoreOracle catcon.pl program is used to run a SQL scripts or SQL statements in all PDBS . $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/****AhAhpassword-changed*** -d /export/home/oracle/scripts -l /export/home/oracle/scripts/logs -b give-write_ps give-write_ps.sql -u username/password…
Read MoreHere is the query below. set linesize 500; select TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, to_char(TIMESTAMP,’YYYY-MON-DD HH24:MI:SS’) from all_tab_modifications where table_owner<>’SYS’ and EXTRACT(YEAR FROM TO_DATE(TIMESTAMP, ‘DD-MON-RR’)) > 2010 order by 6;…
Read More