Page History
...
| Column Name | Column Description |
|---|---|
ORFS_UNIT_ID | The ID of the unit caching the I/O wait (N PW_ORUT_UNIT_NAME_N). |
ORFS_DEVICE_ID | The ID of the device caching the I/O wait (N PW_ORDV_DEVICE_NAME_N). |
ORFS_FILE_ID | The ID of the Oracle file caching the I/O wait (N PW_ORFL_FILE_NAME_N). |
ORFS_PDEV_ID | Physical device name (N PW_ORPV_PDEV_NAME_N). |
ORFS_FS_ID | File system name (N PW_ORFY_FS_NAME_N). |
ORFS_LV_ID | Logical volume name (N PW_ORLV_LV_NAME_N). |
ORFS_TIMESTAMP | The time when the session was sampled. |
ORFS_OBJECT_NAME_ID | Object name ID (N PW_OROB_OBJECT_NAME_N). |
ORFS_OBJECT_ID | Object ID. |
ORFS_OBJECT_OWNER_ID | ID of the object owner (N PW_OROO_OBJECT_OWNER_NAME_N). |
ORFS_NAMESPACE_ID | ID of the translation table (PW_ORNN_NAMESPACE_NAME). |
ORFS_MINUTES_COUNT_SUM | Total amount of minutes summed in that row. |
ORFS_PWHG_ID | The hour group ID that matches the time sampled. |
ORFS_DIRECT_IO_SUM | Total time spend in waiting for a direct I/O. |
ORFS_SCATTERED_IO_SUM | Total time spend in waiting for a scattered I/O. |
ORFS_SEQ_IO_SUM | Total time spend in waiting for a sequential I/O. |
ORFS_OTHER_SUM | Total time spend in waiting for an I/O that is not scattered/sequential/direct. |
ORFS_PWII_INSTANCE_ID | The ID of the instance. |
ORFS_RECEIVED_TIMESTAMP | The timestamp that the row was loaded into the PW. |
ORFS_STORAGE_TYPE | Type of storage. |
ORFS_SUB_OBJECT_NAME_ID | ID of the sub object name (N PW_OROB_OBJECT_NAME_N). |
ORFS_IN_ORACLE_TIME_SUM | Total time spent in Oracle. |
ORFS_ROW_LOCK_SUM | Total time spent in waiting for a row lock. |
ORFS_TABLE_LOCK_SUM | Total time spent in waiting for a table lock. |
ORFS_BUFFER_WAIT_SUM | Total time spent in waiting for a buffer wait. |
ORFS_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
PW_ORST_STATEMENTS
Stores general information about statements.
| Column Name | Column Description |
|---|---|
ORST_ORST_SHV | Hash value (calculation based on the statement text). |
ORST_TEXT | Text of the statement. |
ORST_TEXT_VARCHAR | First 1299 characters of unformatted text of the statement. |
ORST_IS_FORMATTED | Y/N flag indicating whether the statement text is formatted. |
ORST_BIND_VARIABLES_SUM | Sum of the bind variables. |
ORST_CONSISTENT_HV | Precise's consistent hash value. |
PW_ORSN_STATEMENT_INFO
Stores additional information about statements.
| Column Name | Column Description |
|---|---|
ORSN_STATEMENT_ID | Unique statement identifier. |
ORSN_INSTANCE_ID | Instance ID. |
ORSN_SHV | Hash value calculation based on the statement text. |
ORSN_IS_ALTERNATIVE | The statement is saved as a related statement (alternative for other statement). |
ORSN_SOURCE_TYPE |
|
ORSN_CABINET_NAME | Name of the cabinet. |
ORSN_FOLDER_NAME | Name of the folder. |
ORSN_STATEMENT_NAME | Name of the statement. |
ORSN_ORIG_STMT_ID | For related statements; original statement ID. |
ORSN_USERNAME | Statement's schema. |
ORSN_OPTIMIZER | Not used. |
ORSN_STIME | Last time the statement was updated. |
ORSN_PTIME | Last time the statement was explained. |
ORSN_HASH_VALUE | Oracle's hash value. |
ORSN_SOURCE | Source file name of gathered statements. |
ORSN_STATEMENT_TYPE | Type of the statement (such as select, insert, and so on). |
ORSN_EXPLAIN_ERROR | Oracle error that occurred during an explain. |
ORSN_LAST_COST | Cost of the statement in the last explain. |
ORSN_LAST_PLANID | Plan ID of the last explain. |
ORSN_LAST_PLAN_HASH | Hash value calculation based on the last execution plan of the statement. |
ORSN_LAST_VIEWED | Not used. |
ORSN_COMMENTS | Comments. |