Page History
...
| Column Name | Column Description |
|---|---|
ORSS_SHV | The statement hash value. |
ORSS_TIMESTAMP | Time the session was sampled. |
ORSS_PWHG_ID | ID of the hour group that matches the time sampled. |
ORSS_DURATION_SUM | Total elapsed time. |
ORSS_IN_ORACLE_TIME_SUM | Total time spent inside Oracle. |
ORSS_REQUEST_WAIT_TIME_SUM | Total time spent waiting for client requests. |
ORSS_OR_OR_COMM_WAIT_TIME_SUM | Total time Oracle spent waiting for another Oracle instance. |
ORSS_RSRC_MNGR_WAIT_TIME_SUM | The time Oracle spent waiting for a resource to become available, if the database manager is enabled. |
ORSS_RAC_OPS_WAIT_TIME_SUM | The time Oracle spent waiting for RAC or OPS synchronization. |
ORSS_OR_CL_COMM_WAIT_TIME | The time Oracle spent waiting for data sent to the client (usually as a result of a SELECT statement), or data sent from a client (usually as a result of bind variables). |
ORSS_MINUTES_COUNT_SUM | Total amount of minutes summed in that row. |
ORSS_MTS_WAIT_TIME_SUM | Total time spent waiting for a multithreaded server. |
ORSS_MISC_TIME_SUM | Total time spent waiting for miscellaneous waits. |
ORSS_USING_CPU_TIME_SUM | Total time of CPU use. |
ORSS_CPU_WAIT_TIME_SUM | Total time spent waiting for CPU. |
ORSS_IO_WAIT_TIME_SUM | Total time spent waiting for I/O. |
ORSS_MEMORY_WAIT_TIME_SUM | Total time spent waiting for memory. |
ORSS_OTHER_HOST_WAIT_TIME_SUM | Total time spent waiting for another host. |
ORSS_TABLE_LOCK_WAIT_TIME_SUM | Total time spent waiting for a table lock. |
ORSS_ROW_LOCK_WAIT_TIME_SUM | Total time spent waiting for a row lock. |
ORSS_SHARED_POOL_WAIT_TIME_SUM | Total time spent waiting for a shared pool (library cache or row cache). |
ORSS_BUFFER_WAIT_TIME_SUM | Total time spent waiting for buffer waits. |
ORSS_ROLLBACK_SEG_WAIT_TIME_SUM | Total time spent waiting for a rollback segment. |
ORSS_REDO_BUFFER_WAIT_TIME_SUM | Total time spent waiting for redo log buffers. |
ORSS_LOG_S_AND_C_WAIT_TIME_SUM | Total time spent waiting for a log switch. |
ORSS_OTHER_LOCK_WAIT_TIME | Other lock wait is for all the locking that does not fall in the other locking states. It is for Streams, Latches and other internal locking in Oracle. |
ORSS_BG_PROCESS_WAIT_TIME_SUM | Total time spent waiting for a background process. |
ORSS_PQ_SYNC_WAIT_TIME_SUM | Total time spent waiting for a parallel query synchronization. |
ORSS_PQ_SERVER_WAIT_TIME_SUM | Total time spent waiting for a parallel query server. |
ORSS_OTHER_WAIT_TIME_SUM | Total time spent waiting for other waits. |
ORSS_CONSISTENT_GETS_STAT_SUM | Total number of buffers for a consistent read. |
ORSS_DB_BLOCK_GETS_STAT_SUM | Total number of buffers for a current read. |
ORSS_OTR_INT_LCK_WAIT_STAT_SUM | Total number of enqueue waits. |
ORSS_EXEC_COUNT_TOTAL_STAT_SUM | Total number of times EXECUTE was called. |
ORSS_PARSE_COUNT_TOTL_STAT_SUM | Total number of times PARSE was called. |
ORSS_PARSE_COUNT_HARD_STAT_SUM | Total number of times PARSE HARD was called (had to re-parse). |
ORSS_PARSE_TIME_CPU_STAT_SUM | Total CPU time spent on parsing. |
ORSS_RECURSIVE_CALLS_STAT_SUM | Total number of recursive calls. |
ORSS_SORT_MEMORY_STAT_SUM | Total number of sorts done in memory. |
ORSS_SORT_DISK_STAT_SUM | Total number of sorts done on disk. |
ORSS_TABLE_SCAN_LONG_STAT_SUM | Total number of long table scans. |
ORSS_USER_CALLS_STAT_SUM | Total number of user calls. |
ORSS_PHYSICAL_READS_STAT_SUM | Total number of disk reads. |
ORSS_PWII_INSTANCE_ID | ID of the instance. |
ORSS_OPENS_AND_FETCHES_SUM | Total number of open and fetches. |
ORSS_PARENT_SHV | Name of the PL/SQL that ran the SQL statement. |
ORSS_MIN_PARALLEL_DEGREE_MIN | Minimum parallel degree used to run the statement. |
ORSS_MAX_PARALLEL_DEGREE_MAX | Maximum parallel degree used to run the statement. |
ORSS_RECEIVED_TIMESTAMP | Timestamp at which the row was loaded into the PMDB. |
ORSS_BUFFER_GETS_SUM | Total time spent getting buffers. |
ORSS_ROWS_PROCESSED_SUM | Total number of rows processed. |
ORSS_EXEC_NO_SUM | Total number of statement executions. |
ORSS_SQL_ID_MIN | Minimum Oracle's SQL ID. |
ORSS_HASH_VALUE_MIN | Minimum Oracle's hash value. |
ORSS_PLAN_HASH_VALUE | Oracle's plan hash value. |
ORSS_END_OF_FETCH_COUNT_SUM | Number of END OF FETCHs. |
ORSS_VERSION_COUNT_MAX | Number of versions. |
PW_ORFS_FILES_STATS_T
Stores performance statistics about datafiles per hour.
| 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_RECIEVED_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_S UM The time Oracle spent waiting for RAC or OPS synchronization.