Find / Check Hot/Frequently Accessed Objects in Oracle 10g 11g Database Using v$db_object_cache

V$DB_OBJECT_CACHE gives the details of database objects in the shared pool. It includes all objects like tables, indexes, plsql objects-procedure, function, package and etc. The execution column provides you the number of execution for each object.

Below mentioned EXAMPLE provide you the object type wise details of the object under APPUSER.
SQL> SELECT type, COUNT(executions)
FROM v$db_object_cache
where owner ='APPUSER'
GROUP BY type
ORDER BY 2 DESC  ;

TYPE                 COUNT(EXECUTIONS)
-------------------- -----------------
TABLE                              842
CURSOR                              27
VIEW                                16
TRIGGER                             13
SEQUENCE                             3
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google