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