[Home] [Help] [Dependency Information]
Object Name: | CACHE_STATS_1$ |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
I_CACHE_STATS_1 | NORMAL | NONUNIQUE | SYSTEM |
DATAOBJ#
INST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATAOBJ# | NUMBER | Yes | ||
INST_ID | NUMBER | Yes | ||
CACHED_AVG | NUMBER | |||
CACHED_SQR_AVG | NUMBER | |||
CACHED_NO | NUMBER | |||
CACHED_SEQ_NO | NUMBER | |||
CHR_AVG | NUMBER | |||
CHR_SQR_AVG | NUMBER | |||
CHR_NO | NUMBER | |||
CHR_SEQ_NO | NUMBER | |||
LGR_SUM | NUMBER | |||
LGR_LAST | NUMBER | |||
PHR_LAST | NUMBER | |||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | NUMBER | |||
SPARE4 | NUMBER | |||
SPARE5 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DATAOBJ#
, INST_ID
, CACHED_AVG
, CACHED_SQR_AVG
, CACHED_NO
, CACHED_SEQ_NO
, CHR_AVG
, CHR_SQR_AVG
, CHR_NO
, CHR_SEQ_NO
, LGR_SUM
, LGR_LAST
, PHR_LAST
, SPARE1
, SPARE2
, SPARE3
, SPARE4
, SPARE5
FROM SYS.CACHE_STATS_1$;
SYS.CACHE_STATS_1$ does not reference any database object
SYS.CACHE_STATS_1$ is referenced by following:
|
|
|