Posted on December 25, 2016 by mudhalvan
Issue: When the DB Performance issue is reported, After checking found the server load is very low, CPU/IO 90+ percent free. But many sessiones waiting on event “resmgr:cpu quantum”. From AWR report we can see “resmgr:cpu quantum” is the TOP one consuming 100% DB time What/Why resmgr:cpu quantum : “resmgr:cpu quantum” means a session is waiting in a resource queue,
Read More »
Posted on August 3, 2016 by mudhalvan
DBMS_SYSTEM package contains a number of procedures that can be useful. Oracle clearly state that these procedures are not supported so use at your own risk. The package DBMS_SYSTEM is installed by running the script $ORACLE_HOME/rdbms/admin/dbmsutil.sql This script is internally called by $ORACLE_HOME/rdbms/admin/catproc.sql By default only the SYS user can execute procedures and functions in this package. To allow other
Read More »