V$ROWCACHE

V$ROWCACHE displays statistics for data dictionary activity. Each row contains statistics for one data dictionary cache.


Column Datatype Description

CACHE#

NUMBER

Row cache ID number

TYPE

VARCHAR2(11)

Parent or subordinate row cache type

SUBORDINATE#

NUMBER

Subordinate set number

PARAMETER

VARCHAR2(32)

Name of the initialization parameter that determines the number of entries in the data dictionary cache

COUNT

NUMBER

Total number of entries in the cache

USAGE

NUMBER

Number of cache entries that contain valid data

FIXED

NUMBER

Number of fixed entries in the cache

GETS

NUMBER

Total number of requests for information on the data object

FASTGETS

NUMBER

Reserved for internal use

GETMISSES

NUMBER

Number of data requests resulting in cache misses

SCANS

NUMBER

Number of scan requests

SCANMISSES

NUMBER

Number of times a scan failed to find the data in the cache

SCANCOMPLETES

NUMBER

For a list of subordinate entries, the number of times the list was scanned completely

MODIFICATIONS

NUMBER

Number of inserts, updates, and deletions

FLUSHES

NUMBER

Number of times flushed to disk

DLM_REQUESTS

NUMBER

Number of DLM requests

DLM_CONFLICTS

NUMBER

Number of DLM conflicts

DLM_RELEASES

NUMBER

Number of DLM releases

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data