Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…
Read MoreQuery will find out TOP Elapsed time SQL in certain hours with below script SELECT st.sql_text, sub.sql_id, sub.ELAPSED_TIME PER_EXEC_ELAPSED_TIME_MINUTES FROM DBA_HIST_SQLTEXT st, ( SELECT t.sql_id, ROUND ( SUM (t.elapsed_time_delta /…
Read MoreProvided script will find out the UNDO tablespace blocks usage to the corresponding SQL ID which you will provide. select dhs.sql_id, round(sum((vu.activeblks*8)/1024)) ActiveUNDOMB, round(max((vu.unexpiredblks*8)/1024)) UnexpiredUNDOMB ,max(vu.tuned_undoretention)TunedUndo, max(vu.begin_time)newest_time from v$undostat vu…
Read MoreHi All, In Oracle SuperCluster Environment we use important command ‘clrg’ for stopping and Starting of Oracle Web tier and Concurrent Manager Services. clrg stands for clresourcegroup, which assist us…
Read MoreAPPLIES TO: Oracle XML Gateway - Version 11.5 to 12.2.7 [Release 11.5 to 12.2] Information in this document applies to any platform. GOAL: Provide a SQL Script to Determine if…
Read MoreAPPLIES TO: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2] Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine -…
Read MoreAPPLIES TO: Enterprise Manager Base Platform - Version 10.1.0.2 to 11.1.0.1 [Release 10.1 to 11.1] Generic UNIX SYMPTOMS: The Grid Control Management Agent has been installed in a Unix machine.…
Read MoreAPPLIES TO: Enterprise Manager Base Platform - Version 12.1.0.1.0 and later Generic UNIX Generic Linux SYMPTOMS: The Cloud Control Management Agent has been installed on a Unix machine. Trying to…
Read MoreAPPLIES TO: Oracle Workflow - Version 12.1.3 to 12.2 [Release 12.1 to 12.2] Information in this document applies to any platform. SYMPTOMS: On Oracle Applications Release 12.1.3 When attempting to…
Read MoreGOAL: Q1: How to query the hidden initialization parameters in sql ? Q2: How to change these hidden parameters? SOLUTION: A1: The hidden parameters start with an "_".They can…
Read More