Page History
...
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORRO_PWII_INSTANCE_ID | ID of the database (not null number (9)). |
ORRO_TIMESTAMP | Date of the sampling (not null date). |
ORRO_SEGMENT_ID | Name of the rollback segment. (N PW_ORSB_SEGMENT_NAME_N) (number(9)). |
ORRO_USN_SUM | Number of the rollback segment (number). |
ORRO_EXTENTS_SUM | Number of extents in the rollback segment (number). |
ORRO_RSSIZE_SUM | Size of the rollback segment in bytes. This values differs by the number of bytes in one database block from the value of the........(number). |
ORRO_WRITES_SUM | Number of bytes written to the rollback segment (number). |
ORRO_XACTS_SUM | Number of active transactions (number). |
ORRO_GETS_SUM | Number of header gets (number). |
ORRO_WAITS_SUM | Number of header waits |
| (number). | |
ORRO_OPTSIZE_SUM | Optimal size of rollback segment (number). |
ORRO_HWMSIZE_SUM | High water mark of rollback segment size (number). |
ORRO_SHRINKS_SUM | Number of times the size of a rollback segment decreases. Column name Column description (number). |
ORRO_WRAPS_SUM | Number of times the rollback segment is wrapped (number). |
ORRO_EXTENDS_SUM | Number of times rollback segment size is extended (number). |
ORRO_AVESHRINK_SUM | Average shrink size of the rollback segment (number). |
ORRO_AVEACTIVE_SUM | Current size of active extents, averaged over time (number). |
ORRO_STATUS_ID | Status of the rollback segment (N PW_ORTU_STATUS_NAME_N) (number (9)). |
ORRO_CUREXT_SUM | Current extent (number). |
ORRO_CURBLK_SUM | Current block (number). |
ORRO_MINUTES_COUNT_SUM | Total amount of minutes summed in the row (not null number (9)). |
ORRO_PWHG_ID | The hour group ID that matches the sampled time (not null number (4)). |
ORRO_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORRW_V_ROWCACHE_H
Stores statistics for data dictionary activity. Each row contains statistics for one data dictionary cache.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORRW_PWII_INSTANCE_ID | ID of the database. |
ORRW_TIMESTAMP | Timestamp of the sampling. |
ORRW_CACHE_NUM | Number of the row cache. |
ORRW_CACHE_TYPE_ID | Type of the parent or subordinate row cache (N PW_ORCA_CACHE_TYPE_N). |
ORRW_SUBORDINATE_NUM | Subordinate set number. |
ORRW_PARAMETER_ID | Name of the initialization parameter that determines the number of entries in the data dictionary cache (N PW_ORPA_PARAMETER_N). |
ORRW_GETS_SUM | Total number of requests for information on the data object. |
ORRW_GETMISSES_SUM | Total number of data requests resulting in cache misses. |
ORRW_COUNT_SUM | Total number of entries in the cache. |
ORRW_USAGE_SUM | Total number of cache entries that contain valid data. |
ORRW_FIXED_SUM | Total number of fixed entries in the cache. |
ORRW_SCANS_SUM | Total number of scan requests. |
ORRW_SCANMISSES_SUM | Total number of times a scan failed to find the data in the cache. |
ORRW_SCANCOMPLETES_SUM | Total number of times the list was scanned completely. |
ORRW_DLM_REQUESTS_SUM | Total number of DLM requests. Column name Column description. |
ORRW_DLM_CONFLICTS_SUM | Total number of DLM conflicts. |
ORRW_DLM_RELEASES_SUM | Total number of DLM releases. |
ORRW_MODIFICATIONS_SUM | Total number of inserts, updates, and deletions. |
ORRW_FLUSHES_SUM | Total number of times flushed to disk. |
ORRW_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORRW_PWHG_ID | The hour group ID that matches the sampled time. |
ORRW_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORSE_V_SYSTEM_EVENT_H
Stores information on total waits for an event.
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
ORSE_PWII_INSTANCE_ID | ID of the instance. |
ORSE_TIMESTAMP | The date of the sampling. |
ORSE_EVENT_ID | Event name (N PW_OREI_EVENT_N). |
ORSE_TOTAL_WAITS_SUM | Total number of waits for this event. |
ORSE_TOTAL_TIMEOUTS_SUM | Total number of timeouts for this event. |
ORSE_TIME_WAITED_SUM | Total amount of time waited for this event (in hundredths of a second). |
ORSE_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORSE_PWHG_ID | The hour group ID that matches the time sampled. |
ORSE_RECEIVED_TIMESTAMP | The timestamp that the statement was received. |
PW_ORSG_V_SGASTAT_H
Stores detailed information on the system global area (SGA).
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORSG_PWII_INSTANCE_ID | ID of the database. |
ORSG_TIMESTAMP | Date of the sampling. |
ORSG_POOL_ID | The pool in which the memory in NAME resides (N PW_ORPL_POOL_N). |
ORSG_SGA_COMPONENT_ID | Component name (N PW_ORSM_SGA_COMPONENT_N). |
ORSG_BYTES_SUM | Memory size in bytes. |
ORSG_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORSG_PWHG_ID | The hour group ID that matches the sampled size. |
ORSG_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |