This Query will provide much information about the multiple hash plans… select SQL_ID , PLAN_HASH_VALUE , sum(EXECUTIONS_DELTA) EXECUTIONS , sum(ROWS_PROCESSED_DELTA) CROWS , trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS , trunc(sum(ELAPSED_TIME_DELTA)/1000000/60) ELA_MINS from DBA_HIST_SQLSTAT S,…
Read MoreBrief about exam: There were 75 Questions and 90 minutes(1 hour 30 minutes) was alloted to complete this exam. We can complete this exam within 1 hour 15 mins after…
Read MoreBasic understanding: The Information Technology Infrastructure Library (ITIL) mainly deals with services, is a set of concepts and practices for Information Technology Services Management (ITSM), Information Technology (IT) development and…
Read MoreFind Index Fragmentation and Usage To Find Index Fragmentation ~~~~~~~~~~~~~~~~~~~~~~~~~~~ analyze index <index_name> validate structure; select round((del_lf_rows/lf_rows)*100,2) ratio, height, lf_blks, lf_rows from index_stats; We are comparing the ratio between no…
Read MoreTroubleshoot RMAN-06214 error RMAN> DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPE DISK; If error still occurs, then try the below RMAN> CROSSCHECK COPY OF CONTROLFILE; rman> DELETE FORCE NOPROMPT OBSOLETE DEVICE…
Read MoreFix for ORA-03113: end-of-file on communication channel Oracle Database Server 12c Here is how to fix ORA-03113: end-of-file on communication channel [oracle@host ~]$ sqlplus / as sysdba … … Copyright…
Read MoreCREATE OR REPLACE PACKAGE BODY APPS.XXWEBADI_MTL_ONHANDQTY_PKG AS PROCEDURE XXWEBADI_MTL_ONHAND_QTY_INS ( errbuff OUT VARCHAR2, retcode OUT NUMBER ) IS LV_BATCH_MODE VARCHAR2(3); LN_BATCH_ID NUMBER; LV_ERROR VARCHAR2(240) := ‘Unable to load reocords in…
Read MoreE-Business Suite Applications Technology Stack, HTTP / IAS Server related issues Users report cache initialization errors in OA Framework related pages. The oacorestd.err file shows: Exception in static block of…
Read MoreError Noticed in the log file $LOG_HOME/ora/10.1.3/Apache Solution: 1. Noticed the When we have started the Application Services the load average was 1. 2. When executed ps -ef |grep applmgr…
Read MoreError : http 500 internal server error: java.lang.NoClassDefFoundError at oracle.apps.fnd.sso.AppsLoginRedirect.doGet(AppsLoginRedirect.java:623) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.0.0)]. server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) Solution : $cd $ADMIN_SCRIPTS_HOME $adopmnctl.sh stopall…
Read More