4.332 DBA_HIST_IM_SEG_STAT
DBA_HIST_IM_SEG_STAT
displays information about historical in-memory segment statistics.
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 |
|
|
|
Size of in-memory version of the segment in bytes |
|
|
|
Count of segment statistics |
|
|
|
Delta values for in-memory scans |
|
|
|
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 |
|
|
|
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 database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|