Page History
...
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORLA_PWII_INSTANCE_ID | ID of the database. |
ORLA_TIMESTAMP | Timestamp of the sampling. |
ORLA_LATCH_NUM | Number of the latch. |
ORLA_LEVEL_NUM | Level of the latch. |
ORLA_LATCH_ID | ID of the latch (N PW_ORLT_LATCH_N). |
ORLA_GETS_SUM | Total number of times a wait was obtained. |
ORLA_MISSES_SUM | Total number of times a wait was obtained, but failed on the first try. |
ORLA_SLEEPS_SUM | Total number of times slept when wanting a wait. |
ORLA_IMMEDIATE_GETS_SUM | Total number of times obtained without a wait. |
ORLA_IMMEDIATE_MISSES_SUM | Total number of times failed to get without a wait. |
ORLA_WAITERS_WOKEN_SUM | Total number of times a wait was awoken. |
ORLA_WAITS_HOLDING_LATCH_SUM | Total number of waits, while holding a different latch. |
ORLA_SPIN_GETS_SUM | Gets that missed the first try, but succeeded on spin. |
ORLA_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORLA_PWHG_ID | The hour group ID that matches the sampled time. |
ORLA_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORLC_V_LICENSE_H
Stores information about the highest number of concurrent user sessions since the instance started.
| Info |
|---|
The The The The |
| Column Name | Column Description |
|---|---|
ORLC_PWII_INSTANCE_ID | ID of the database. |
ORLC_TIMESTAMP | Timestamp of the sampling. |
ORLC_SESSIONS_HIGHWATER_SUM | Highest number of concurrent user sessions since the instance started. |
ORLC_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
ORLC_PWHG_ID | The hour group ID that matches the sampled time. |
ORLC_RECEIVED_TIMESTAMP | The timestamp when the row was loaded into the PW. |
PW_ORPQ_V_PQ_SYSSTAT_H
Stores system statistics for parallel queries.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
OROT_PWII_INSTANCE_ID | ID of the database. |
OROT_TIMESTAMP | Date of the sampling. |
OROT_STATISTIC_ID | Name of the statistic counter (N PW_ORTI_STATISTIC_N). |
OROT_VALUE_SUM | Total value of the statistic counter. |
OROT_MINUTES_COUNT_SUM | Total amount of minutes summed in the row. |
OROT_PWHG_ID | The hour group ID that matches the sampled time. |
OROT_RECEIVED_TIMESTAMP | The timestamp when the row was loaded into the PW. |
PW_ORQU_V_QUEUE_H
Stores information on multi-thread message queues.
| Info |
|---|
The The The The
|
| Column Name | Column Description |
|---|---|
ORQU_PWII_INSTANCE_ID | ID of the database (not null number (9)). |
ORQU_TIMESTAMP | Date of the sampling (not null date). |
ORQU_NETWORK_ID | Network address of the dispatcher (N PW_ORNT_NETWORK_N) (number (9)). |
ORQU_WAIT_SUM | Total time that all items in this queue have waited. Divide this by TOTALQ for an average wait per item (number). |
ORQU_TOTALQ_SUM | Total number of items that have ever been in the queue (number). |
ORQU_MINUTES_COUNT_SUM | Total amount of minutes summed in the row (not null number (9)). |
ORQU_PWHG_ID | The hour group ID that matches the sampled time (not null number (4)). |
ORQU_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
PW_ORRO_V_ROLLSTAT_H
Stores rollback segment statistics.
| 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. PMDB Reference Guide 215 (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_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. |