5.44 DBA_HIST_SEG_STAT
DBA_HIST_SEG_STAT
displays historical information about segment-level statistics.
This view captures the top segments based on a set of criteria and captures information from V$SEGSTAT
. The total value is the value of the statistics since instance startup. The delta value is the value of the statistics from the BEGIN_INTERVAL_TIME
to the END_INTERVAL_TIME
in the DBA_HIST_SNAPSHOT
view.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Tablespace number |
|
|
|
Dictionary object number |
|
|
|
Data object number |
|
|
|
Cumulative value for logical reads |
|
|
|
Delta value for logical reads |
|
|
|
Cumulative value for buffer busy waits |
|
|
|
Delta value for buffer busy waits |
|
|
|
Cumulative value for db block changes (in blocks) |
|
|
|
Delta value for db block changes (in blocks) |
|
|
|
Cumulative value for physical reads (in blocks) |
|
|
|
Delta value for physical reads (in blocks) |
|
|
|
Cumulative value for physical writes (in blocks) |
|
|
|
Delta value for physical writes (in blocks) |
|
|
|
Cumulative value for physical reads direct (in blocks) |
|
|
|
Delta value for physical reads direct (in blocks) |
|
|
|
Cumulative value for physical writes direct (in blocks) |
|
|
|
Delta value for physical writes direct (in blocks) |
|
|
|
Cumulative value for ITL waits |
|
|
|
Delta value for ITL waits |
|
|
|
Cumulative value for row lock waits |
|
|
|
Delta value for row lock waits |
|
|
|
Cumulative value for global cache CR blocks served |
|
|
|
Delta value for global cache CR blocks served |
|
|
|
Cumulative value for global cache current blocks served |
|
|
|
Delta value for global cache current blocks served |
|
|
|
Cumulative value for global cache buffer busy |
|
|
|
Delta value for global cache buffer busy |
|
|
|
Cumulative value for global cache CR blocks received |
|
|
|
Delta value for global cache CR blocks received |
|
|
|
Cumulative value for global cache current blocks received |
|
|
|
Delta value for global cache current blocks received |
|
|
|
Number of bytes used by user data |
|
|
|
Delta value for space used by user data (in bytes). A negative value indicates the number of bytes deleted in the segment. |
|
|
|
The number of bytes that are allocated |
|
|
|
Delta value for the space allocated (in bytes). A negative value indicates the number of bytes deallocated to the tablespace. |
|
|
|
Cumulative value for table scans |
|
|
|
Delta value for table scans |
|
|
|
Cumulative value of number of chained row pieces that can be eliminated by table reorganization |
|
|
|
Delta value of number of chained row pieces that can be eliminated by table reorganization |
|
|
|
Cumulative value of number of physical read I/O requests issued for the monitored segment |
|
|
|
Delta value of number of physical read I/O requests issued for the monitored segment |
|
|
|
Cumulative value of number of physical write I/O requests issued for the monitored segment |
|
|
|
Delta value of number of physical write I/O requests issued for the monitored segment |
|
|
|
Cumulative value of number of physical reads from Database Smart Flash Cache for the monitored segment |
|
|
|
Delta value of number of physical reads from Database Smart Flash Cache for the monitored segment |
|
|
|
Count of segment statistics |
|
|
|
Delta values for in-memory scans |
|
|
|
Count of compression units (CUs) populated per segment |
|
|
|
Delta value for compression unit (CU) populate operations |
|
|
|
Count of CUs repopulated per segment |
|
|
|
Delta value for compression unit (CU) repopulate operations |
|
|
|
The total number of changes that were part of an update or delete operation that were made to segment blocks |
|
|
|
Delta value for database block changes |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: