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

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Website Stats