Page History
...
Stores information about the table's analyze statistics over time.
| Column Name | Column Description |
|---|---|
ORTA_DATABASE_ID | ID of the database. |
ORTA_CHANGE_TIME | Date of the change. |
ORTA_OWNER | Owner of the table. |
ORTA_OBJECT_NAME | Name of the table. |
ORTA_EXTENTS | Number of extents in the table. |
ORTA_SEGMENT_BLOCKS | Number of blocks allocated to the table. |
ORTA_NUM_ROWS | Number of rows in the table. |
ORTA_BLOCKS | Number of used data blocks in the table. |
ORTA_EMPTY_BLOCKS | Number of empty (never used) data blocks in the table. |
ORTA_AVG_SPACE | Average amount of freed space (in bytes) in a data block allocated to the table. |
ORTA_CHAIN_CNT | Number of rows in the table that are chained from one data block to another or that have migrated to a new block, requiring a link to preserve the old ROWID. |
ORTA_AVG_ROW_LEN | Average row length in the table in bytes. |
ORTA_LAST_ANALYZED | Date this table was most recently analyzed. |
PS_ORIO_INDEXES_OVER_TIME
Stores information about the index's analyze statistics over time.
| Column Name | Column Description |
|---|---|
ORIO_DATABASE_ID | ID of the database. |
ORIO_CHANGE_TIME | Date of the change. |
ORIO_OWNER | Owner of the index. |
ORIO_OBJECT_NAME | Name of the index. |
ORIO_TABLE_OWNER | Owner of the table. |
ORIO_TABLE_NAME | Name of the table. |
ORIO_BLEVEL | B*-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same. |
ORIO_LEAF_BLOCKS |
ORIO_DISTINCT_KEYSORIO_AVG_LEAF_BLOCKS_PER_KEYORIO_ORIO_ORIO_ORIO_...
| Number of leaf blocks in the index. | |
ORIO_DISTINCT_KEYS | Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table ( |
ORIO_AVG_LEAF_BLOCKS_PER |
...
_KEY | Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1. |
ORIO_AVG_DATA_BLOCKS_PER |
...
_KEY | Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer. This statistic is the average number of data blocks that contain rows with a given value for the indexed columns. |
ORIO_CLUSTERING_FACTOR | Indicates the amount of order of the rows in the table based on the values of the index.
|
ORIO_NUM_ROWS | Number of rows in the index. |
ORIO_SAMPLE_SIZE | Sample size used in analyzing this table. |
ORIO_LAST_ANALYZED | Date this table was most recently analyzed. |
PS_ORCO_COLUMNS_OVER_TIME
Stores information about the table column's analyze statistics over time.
| Column Name | Column Description |
|---|---|
ORCO_DATABASE_ID | ID of the database. |
ORCO_CHANGE_TIME | Date of the change. |
ORCO_OWNER | Owner of the table. |
ORCO_TABLE_NAME | Name of the table. |
ORCO_COLUMN_NAME | Name of the column. |
ORCO_NUM_DISTINCT | Number of distinct values in the column. |
ORCO_DENSITY | Density of the column. |
ORCO_NUM_NULLS | Number of null values in the column. |
ORCO_NUM_BUCKETS | Number of buckets used to analyze the column. |
ORCO_LAST_ANALYZED | Date this table was most recently analyzed. |
PW_ORWA_V_WAITSTAT_H
Stores information about Oracle block contention statistics over time.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORWA_PWII_INSTANCE_ID | ID of the database. |
ORWA_TIMESTAMP | Date of the sampling. |
ORWA_CLASS_ID | Class of the block (N PW_ORCL_CLASS_N). |
ORWA_COUNT_SUM | Number of waits by this OPERATION for this CLASS of the block. |
ORWA_TIME_SUM | Total value of the wait times for all waits by this OPERATION for this CLASS of the block. |
ORWA_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORWA_PWHG_ID | The hour group ID that matches the sampled time. |
ORWA_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |