wfbkg.sql WorkFlow BacKGround engine, starts the background engine, running for the indicated number of minutes. wfbkgchk.sql WorkFlow Background Check. It displays a status report on background work waiting to…
Read MoreEBS R12.2 ADOP phases and parameters 1) Prepare – Starts a new patching cycle. Syntax: adop phase=prepare 2) Apply – Used to apply a patch to the patch file system…
Read MoreConcurrent 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 More