V$RESULT_CACHE_OBJECTS

ID

NUMBER

Identifier for the cache object (also the ID of the first block)

TYPE

VARCHAR2(10)

Type of the cache object:

• Result

• Dependency

STATUS

VARCHAR2(9)

Status of the object:

• New - Result is still under construction

• Published - Result is available for use

• Bypass - Result will be bypassed from use

• Expired - Result has exceeded expiration time

• Invalid - Result is no longer available for use

BUCKET_NO

NUMBER

Internal hash bucket for the object

HASH

NUMBER

Hash value for the object

NAME

VARCHAR2(128)

Name (for example, SQL prefix or PL/SQL function name)

NAMESPACE

VARCHAR2(5)

Namespace:

• SQL

• PLSQL

• KEY VECTOR

CREATION_TIMESTAMP

DATE

Time when the object was created

CREATOR_UID

NUMBER

UID that created the object

DEPEND_COUNT

NUMBER

Number of dependencies (TYPE = Result) or dependents (TYPE = Dependency)

BLOCK_COUNT

NUMBER

Total number of blocks in the cached object

SCN

NUMBER

Build SCN (TYPE = Result) or invalidation SCN (TYPE = Dependency)

COLUMN_COUNT

NUMBER

Number of columns in the cached result

PIN_COUNT

NUMBER

Number of active scans on this result¹

SCAN_COUNT

NUMBER

Total number of scans initiated on the cached result¹

ROW_COUNT

NUMBER

Total number of rows in the cached result¹

ROW_SIZE_MAX

NUMBER

Size of the largest row (in bytes)¹

ROW_SIZE_MIN

NUMBER

Size of the smallest row (in bytes)¹

ROW_SIZE_AVG

NUMBER

Average size of a row (in bytes)¹

BUILD_TIME

NUMBER

Amount of time (in hundredths of a second) it took to build the cached result¹

LRU_NUMBER

NUMBER

LRU list position (the smaller the value, the more recent the usage)¹

OBJECT_NO

NUMBER

Dictionary object number of the dependency object

INVALIDATIONS

NUMBER

Number of times the object has invalidated its dependents²

SPACE_OVERHEAD

NUMBER

Overhead (in bytes) for the result¹

SPACE_UNUSED

NUMBER

Unused space (in bytes) for the result¹

CACHE_ID

VARCHAR2(93)

CacheId for the result (object name if it's a dependency)

CACHE_KEY

VARCHAR2(93)

CacheKey for the result (object name if it's a dependency)

CHECKSUM

NUMBER

Checksum for the result object. The checksum is computed over all the blocks in the result cache object minus the object header.

EDITION_ID

NUMBER

Shows the edition's object ID that was in use when the result was calculated

DB_LINK³

VARCHAR2(3)

Possible values:

• YES: If the result cache object references a remote database object

• NO: If the result cache object does not reference a remote database object

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