APPLIES TO: Oracle Concurrent Processing - Version 12.1.3 to 12.1.3 [Release 12.1] Oracle Solaris on SPARC (64-bit) SYMPTOMS: Error in the Concurrent Manager Log File : ld.so.1: mail: warning: /usr/lib/extendedFILE.so.1:…
Read MoreMaximum Security Zones provides both preventative and detective security controls for cloud environment. Maximum Security Zones is the preventative control, designed to stop from making bad implementation choices that would…
Read MoreEnterprise 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 More