Page History
...
| 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. |
PW_ORSY_V_SYSSTAT_H
Stores system statistics information.
| Column Name | Column Description |
|---|---|
ORSY_PWII_INSTANCE_ID | ID of the database. |
ORSY_TMESTAMP | Date of the sampling. |
ORSY_STATISTIC_NUM | Number of the statistic counter. Note that statistic numbers are not guaranteed to remain constant from one release to another. Therefore you should rely on the statistic name, rather than its number in your applications. |
ORSY_STATISTIC_ID | Name of the statistic counter. ( |
ORSY_CLASS | Number representing one or more statistics class. The following class numbers are additive:
|
ORSY_VALUE_SUM | Value of the statistic counter. |
ORSY_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORSY_PWHG_ID | The hour group ID that matches the sampled time. |
ORSY_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORPG_V_PCASTAT_H
Stores detailed information on the program global area (PGA_. The data is collected for databases of Precise 9.2 and later.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORPG_PWII_INSTANCE_ID | ID of the database. |
ORPG_TIMESTAMP | Date of the sampling. |
ORPG_NAME_ID | Name of the statistic counter. (N PW_ORNE_NAMEPGA_N) |
ORPG_VALUE_AVG | Average value of the statistic counter. |
ORPG_VALUE_SUM | Total value of the statistic counter. |
ORPG_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORPG_PWHG_ID | The hour group ID that matches the sampled time. |
ORPG_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORTM_V_SYS_TIME_MODEL_H
Stores detailed information on the database time model. This is the partition of the database time spent for connection management, parsing SQL and Java executions, as well as overall database statistics. The data is collected for databases of version 10 and higher.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORTM_PWII_INSTANCE_ID | ID of the database. |
ORTM_TIMESTAMP | Date of the sampling. |
ORTM_STAT_NAME_ID | Name of the statistic counter. (N PW_ORTO_STAT_NAME_N) |
ORTM_STAT_ID | ID of the statistic counter. |
ORTM_VALUE_SUM | Total value of the statistic counter. |
ORTM_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORTM_PWHG_ID | The hour group ID that matches the sampled time. |
ORTM_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |