7.264 V$HEAT_MAP_SEGMENT
V$HEAT_MAP_SEGMENT
displays real-time segment access information.
Column | Datatype | Description |
---|---|---|
|
|
Name of the object |
|
|
Name of the subobject |
|
|
Object number |
|
|
Data object number |
|
|
ID of the tablespace containing the segment whose heat map is tracked |
|
|
Timestamp of current activity tracking |
|
|
Indicates whether the segment has write access: ( |
|
|
Indicates whether the segment has read access: ( |
|
|
Indicates whether the segment has full table scan: ( |
|
|
Indicates whether the segment has lookup scan: ( |
|
|
Number of segment writes |
|
|
Number of table scans |
|
|
Number of lookup scans |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also: