Page History
...
| Info |
|---|
The The The The
|
| 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_ORFS_ORFS_ORFS_ORFS_ORFS_ORFS_ORFS_ORFS_ORFS_ORFS_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. |