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.
...
Stores information about changes made to the database schema, such as adding, dropping, or modifying tables, indexes, or columns.
| Column Name | Column Description |
|---|---|
ORSM_DATABASE_ID | Database ID of the changed object. |
ORSM_CHANGE_TIME | Time of the change. |
ORSM_CHANGE_TYPE | Type of the change (such as new, deleted, or changed). |
ORSM_OWNER | Name of the object's owner. |
ORSM_OBJECT_NAME | Name of the object that was changed. |
ORSM_BASE_OWNER | Name of the base object's owner. |
ORSM_BASE_OBJECT_NAME | Name of the base object. |
ORSM_SUBOBJECT_NAME | Name of the sub-object. |
ORSM_OBJECT_TYPE | Type of the changed object, such as table or index. |
ORSM_COLUMN_NAME | Name of the column of the object that was changed. |
ORSM_FIELD_NAME | Name of the field. |
ORSM_OLD_VALUE | Value of the field as sampled at the previous run. |
ORSM_NEW_VALUE | Value of the field as sampled at the last run. |
ORSM_COLUMN_LIST | List of column names. |
ORSM_DDL_COMMAND | DDL command that created the object. |
PW_ORSN_STRUCTURE_CHANGE_LOG
Stores information about changes to the database structure, such as changes in redo log files, rollback segments, or initialization parameters.
| Column Name | Column Description |
|---|---|
ORSN_DATABASE_ID | Database ID of the changed object. |
ORSN_CHANGE_TIME | Time of the change. |
ORSN_CHANGE_TYPE | Type of the change, such as new, deleted, or changed. |
ORSN_OWNER | Name of the object's owner. |
ORSN_OBJECT_NAME | Name of the object that was changed. |
ORSN_SUBOBJECT_NAME | Name of the sub-object. |
ORSN_OBJECT_TYPE | Type of the changed object, such as table or index. |
ORSN_COLUMN_NAME | Name of the column of the object that was changed. |
ORSN_FIELD_NAME | Name of the field. |
ORSN_OLD_VALUE | Value of the field as sampled at the previous run. |
ORSN_NEW_VALUE | Value of the field as sampled at the last run. |
ORSN_COLUMN_LIST | List of column names. |
PW_ORPS_PW_SIZE
Stores information about the space usage of Precise Oracle-related objects in the PMDB.
| Column Name | Column Description |
|---|---|
ORPS_SAMPLE_DATE | Time when the analyzed batch started. |
ORPS_ROW_TYPE | Type of row. |
ORPS_LAST_ANALYZED | Last time the PMDB schema was analyzed. |
ORPS_SCHEMA_USED | Total space (in bytes) used by schema change objects that are related to Precise for Oracle. |
ORPS_SCHEMA_FREE | Total space (in bytes) unused by schema change objects that are related to Precise for Oracle. |
ORPS_ |
ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_ORPS_...
SCHEMA_ALLOCATED | Total space (in bytes) allocated to schema change objects that are related to Precise for Oracle. |
ORPS_STATS_USED | Total space (in bytes) used by statistics objects that are related to Precise for Oracle. |
ORPS_STATS_FREE | Total space (in bytes) unused by statistics objects that are related to Precise for Oracle. |
ORPS_STATS_ALLOCATED | Total space (in bytes) allocated to statistics objects that are related to Precise for Oracle. |
ORPS_STRUCT_USED | Total space (in bytes) used by structure objects that are related to Precise for Oracle. |
ORPS_STRUCT_FREE | Total space (in bytes) unused by structure objects that are related to Precise for Oracle. |
ORPS_STRUCT_ALLOCATED | Total space (in bytes) allocated to structure objects that are related to Precise for Oracle. |
ORPS_REP_USED | Total space (in bytes) used by repository objects that are related to Precise for Oracle. |
ORPS_REP_FREE | Total space (in bytes) unused by repository objects that are related to Precise for Oracle. |
ORPS_REP_ALLOCATED | Total space (in bytes) allocated to repository objects that are related to Precise for Oracle. |
ORPS_TOTAL_USED | Total space (in bytes) used by objects that are related to Precise for Oracle. |
ORPS_TOTAL_FREE | Total space (in bytes) unused by objects that are related to Precise for Oracle. |
ORPS_TOTAL_ALLOCATED | Total space allocated to objects that are related to Precise for Oracle. |