7.116 V$BT_SCAN_OBJ_TEMPS
V$BT_SCAN_OBJ_TEMPS
shows the active objects currently tracked by the big table cache.
Column | Datatype | Description |
---|---|---|
|
|
Tablespace number |
|
|
Data object number (objd) |
|
|
Size of the object being scanned on this instance, in blocks |
|
|
Temperature of this object |
|
|
Caching policy of this object. Possible values:
|
|
|
The number of blocks that are cached/allocated in memory for this object |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
"DB_BIG_TABLE_CACHE_PERCENT_TARGET" for more information about enabling the big table cache