DBA Data[Home] [Help] [Dependency Information]

TABLE: SYS.CRC$_RESULT_CACHE_STATS

Object Details
Object Name: CRC$_RESULT_CACHE_STATS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Internal table for client result cache statistics. Statistics are stored as name value pairs. For each client cache ID there will be multiple rows for each statistic.

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: CRC$_RCSTATSPK
  1. ColumnCACHE_ID
  2. ColumnSTAT_ID
Indexes
Index Type Uniqueness Tablespace Column
CRC$_RCSTATSPK NORMAL UNIQUE TablespaceSYSAUX ColumnCACHE_ID
ColumnSTAT_ID
Columns
Name Datatype Length Mandatory Comments
CACHE_ID NUMBER
Yes Unique ID per client cache
STAT_ID NUMBER
Yes ID of the statistic
NAME VARCHAR2 (128)
Name of the statistic
VALUE NUMBER

Value of the statistic
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CACHE_ID
,      STAT_ID
,      NAME
,      VALUE
FROM SYS.CRC$_RESULT_CACHE_STATS;

Dependencies

[top of page]

SYS.CRC$_RESULT_CACHE_STATS does not reference any database object

SYS.CRC$_RESULT_CACHE_STATS is referenced by following:

SchemaSYS
ViewCRCSTATS_$