Data dictionary cache

These views provide information about how the Oracle kernel is managing the data dictionary and library caches:

V$DB_OBJECT_CACHE

Lists tables, indexes, clusters, synonyms, PL/SQL procedures, packages, and triggers that are in the library cache.

V$LIBRARYCACHE

Contains statistics about library cache performance.

V$ROWCACHE

Contains statistics about data dictionary cache performance.

V$SUBCACHE

Lists each subordinate cache in the library cache.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset