Precise for Oracle tables

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column Name	Column Description
`PWII_ID`	ID of the instance. Columns of `XXXX_PWII_INSTANCE_ID` have values from the column.
`PWII_INSTANCE_NAME`	Name of the instance.
`PWII_TECHNOLOGY`	Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).
`PWII_SERVER`	Name of the server on which the instance is installed.

PW_ORAS_APPLICATION_STATS_T

Stores application performance statistics per hour for every combination of program, user, host user, machine, module, action, and work type.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`ORAS_PROGRAM_ID`	The ID of the program that made the Oracle connection `(N PW_ORPR_PROGRAM_NAME_N)`.
`ORAS_USER_ID`	ID of the Oracle schema to which the program is connected `(N PW_ORUS_USER_NAME_N)`.
`ORAS_HOST_USER_ID`	ID of the host user running the program `(N PW_ORHU_HOST_USER_NAME_N)`.
`ORAS_MACHINE_ID`	ID of the operating system machine running the program `(N PW_ORMC_MACHINE_NAME_N)`.
`ORAS_MODULE_ID`	ID of the session’s action as set by calling `dbms_application_info.set_module` `(N PW_ORMD_MODULE_NAME_N)`.
`ORAS_ACTION_ID`	ID of the session’s action as set by calling `dbms_application_info.set_action (N PW_ORAT_ACTION_NAME_N)`.
`ORAS_WORK_TYPE`	ERP work type.
`ORAS_TIMESTAMP`	Time the session was sampled.
`ORAS_MINUTES_COUNT_SUM`	Number of minutes summed in the row.
`ORAS_PWHG_ID`	ID of the hour group that matches the time sampled.
`ORAS_DURATION_SUM`	Total elapsed time.
`ORAS_IN_ORACLE_TIME_SUM`	Total time spent in Oracle.
`ORAS_REQUEST_WAIT_TIME_SUM`	Total time spent in waiting for client requests.
`ORAS_OR_OR_COMM_WAIT_TIME_SUM`	The time Oracle spent waiting for another Oracle instance.
`ORAS_RSRC_MNGR_WAIT_TIME_SUM`	The time Oracle spent waiting for a resource to become available if the database resource manager had been enabled.
`ORAS_RAC_OPS_WAIT_TIME_SUM`	The time Oracle spent waiting for RAC or OPS synchronization.
`ORAS_OR_CL_COMM_WAIT_TIME_SUM`	The time Oracle spent waiting for data sent to the client (usually as a result of a select statement), or data send from a client (usually as a result of bind variables).
`ORAS_MTS_WAIT_TIME_SUM`	Total time spent waiting for a multithreaded server.
`ORAS_MISC_TIME_SUM`	Total time spent waiting for miscellaneous waits.
`ORAS_USING_CPU_TIME_SUM`	Total time of CPU use.
`ORAS_CPU_WAIT_TIME_SUM`	Total time spent waiting for CPU.
`ORAS_IO_WAIT_TIME_SUM`	Total time spent waiting for I/O.
`ORAS_MEMORY_WAIT_TIME`	Total time spent waiting for memory.
`ORAS_OTHER_HOST_WAIT_TIME_SUM`	Total time spent waiting for another host.
`ORAS_TABLE_LOCK_WAIT_TIME_SUM`	Total time spent waiting for a table lock.
`ORAS_ROW_LOCK_WAIT_TIME_SUM`	Total time spent waiting for a row lock.
`ORAS_SHARED_POOL_WAIT_TIME_AUM`	Total time spent waiting for a shared pool (library cache or row cache).
`ORAS_BUFFER_WAIT_TIME_SUM`	Total time spent waiting for buffers.
`ORAS_ROLLBACK_SEG_WAIT_TIME_SUM`	Total time spent waiting for a rollback segment.
`ORAS_REDO_BUFFER_WAIT_TIME`	Total time spent waiting for redo log buffers.
`ORAS_LOG_S_AND_C_WAIT_TIME_SUM`	Total time spent waiting for a log switch and clear waits.
`ORAS_OTHER_LOCK_WAIT_TIME_SUM`	Total time spent waiting for other locks (streams, latches, and internal locks in Oracle).
`ORAS_BG_PROCESS_WAIT_TIME_SUM`	Total time spent waiting for a background process.
`ORAS_PQ_SYNC_WAIT_TIME_SUM`	Total time spent waiting for parallel query synchronization.
`ORAS_PQ_SERVER_WAIT_TIME_SUM`	Total time spent waiting for a parallel query server.
`ORAS_OTHER_WAIT_TIME_SUM`	Total time spent waiting for other waits.
`ORAS_CONSISTENT_GETS_STAT_SUM`	Total number of buffers for a consistent read.
`ORAS_DB_BLOCK_GETS_STAT_SUM`	Total number of buffers for a current read.
`ORAS_OTR_INT_LCK_WAIT_STAT_SUM`	Total number of enqueue waits.
`ORAS_PARSE_COUNT_TOTL_STAT_SUM`	Total number of times PARSE was called.
`ORAS_PARSE_COUNT_HARD_ST_AT_SUM`	Total number of times PARSE HARD was called (had to re-parse).
`ORAS_PARSE_TIME_CPU_STAT_SUM`	Total CPU time spent on parsing.
`ORAS_RECURSIVE_CALLS_STAT_SUM`	Total number of recursive calls.
`ORAS_SORT_MEMORY_STAT_SUM`	Total number of sorts done in memory.
`ORAS_SORT_DISK_STAT_SUM`	Total number of sorts done on disk.
`ORAS_TABLE_SCAN_LONG_STAT_SUM`	Total number of long table scans.
`ORAS_USER_CALLS_STAT_SUM`	Total number of user calls.
`ORAS_PHYSICAL_READS_STAT_SUM`	Total number of disk reads.
`ORAS_PWII_INSTANCE_ID`	ID of the instance.
`ORAS_OPENS_AND_FETCHES_SUM`	Total number of open and fetches.
`ORAS_SESSIONS_SUM`	Total number of sessions.
`ORAS_INTERPOINT_MODE`	Interpoint mode - OA/SAP/PS.
`ORAS_RECEIVED_TIMESTAMP`	Timestamp at which the row was loaded into the PMDB.
`ORAS_SEC_PROG_ID`	Reserved column.
`ORAS_EXEC_NO_SUM`	Total number of executions.

PW_ORSA_STMT_APPL_STATS_T

Stores statistics about the performance of statements inside applications per hour for every combination of program, user, host user, machine, module, action, and work type.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

Column Name	Column Description
`ORSA_PROGRAM_ID`	ID of the program that made the Oracle connection (`N PW_ORPR_PROGRAM_NAME_N`).
`ORSA_USER_ID`	ID of the Oracle schema the program connected to (`N PW_ORUR_USER_NAME_N`).
`ORSA_HOST_USER_ID`	ID of the host user running the program (`N PW_ORHU_HOST_USER_NAME_N`).
`ORSA_MACHINE_ID`	ID of the operating system machine running the program (`N PW_ORMC_MACHINE_NAME_N`).
`ORSA_MODULE_ID`	ID of the session's action as set by calling `dbms_application_info.set_module` (`N PW_ORMD_MODULE_NAME_N`).
`ORSA_ACTION_ID`	ID of the session's action as set by calling `dbms_application_info.set_action` (`N PW_ORAT_ACTION_NAME_N`).
`ORSA_WORK_TYPE`	The ERP work type.
`ORSA_SHV`	The statement hash value.
`ORSA_TIMESTAMP`	Time the session was sampled.
`ORSA_PWHG_ID`	ID of the hour group that matches the time sampled.
`ORSA_DURATION_SUM`	Total elapsed time.
`ORSA_IN_ORACLE_TIME_SUM`	Total time spent inside Oracle.
`ORSA_REQUEST_WAIT_TIME_SUM`	Total time spent waiting for client requests.
`ORSA_OR_OR_COMM_WAIT_TIME_SUM`	Total time Oracle spent waiting for another Oracle instance.
`ORSA_RSRC_MNGR_WAIT_TIME_SUM`	The time Oracle spent waiting for a resource to become available, if the database manager is enabled.
`ORSA_RAC_OPS_WAIT_TIME_SUM`	The time Oracle spent waiting for RAC or OPS synchronization.
`ORSA_OR_CL_COMM_WAIT_TIME_SUM`	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).
`ORSA_MINUTES_COUNT_SUM`	Total amount of minutes summed in that row.
`ORSA_MTS_WAIT_TIME_SUM`	Total time spent waiting for a multithreaded server.
`ORSA_MISC_TIME_SUM`	Total time spent waiting for miscellaneous waits.
`ORSA_USING_CPU_TIME_SUM`	Total time of CPU use.
`ORSA_CPU_WAIT_TIME_SUM`	Total time spent waiting for CPU.
`ORSA_IO_WAIT_TIME_SUM`	Total time spent waiting for I/O.
`ORSA_MEMORY_WAIT_TIME_SUM`	Total time spent waiting for memory.
`ORSA_OTHER_HOST_WAIT_TIME_SUM`	Total time spent waiting for another host.
`ORSA_TABLE_LOCK_WAIT_TIME_SUM`	Total time spent waiting for a table lock.
`ORSA_ROW_LOCK_WAIT_TIME_SUM`	Total time spent waiting for a row lock.
`ORSA_SHARED_POOL_WAIT_TIME_SUM`	Total time spent waiting for a shared pool (library cache or row cache).
`ORSA_BUFFER_WAIT_TIME_SUM`	Total time spent waiting for buffer waits.
`ORSA_ROLLBCK_SEG_WAIT_TIME_SUM`	Total time spent waiting for a rollback segment.
`ORSA_REDO_BUFFER_WAIT_TIME_SUM`	Total time spent waiting for redo log buffers.
`ORSA_BG_PROCESS_WAIT_TIME_SUM`	Total time spent waiting for a background process.
`ORSA_PQ_SYNC_WAIT_TIME_SUM`	Total time spent waiting for a parallel query synchronization.
`ORSA_PQ_SERVER_WAIT_TIME_SUM`	Total time spent waiting for a parallel query server.
`ORSA_OTHER_WAIT_TIME_SUM`	Total time spent waiting for other waits.
`ORSA_CONSISTENT_GETS_STAT_SUM`	Total number of buffers for a consistent read.
`ORSA_DB_BLOCK_GETS_STAT_SUM`	Total number of buffers for a current read.
`ORSA_EXEC_COUNT_TOTAL_STAT_SUM`	Total number of times EXECUTE was called.
`ORSA_PARSE_COUNT_TOTL_STAT_SUM`	Total number of times PARSE was called.
`ORSA_PARSE_COUNT_HARD_STAT_SUM`	Total number of times PARSE HARD was called (had to re-parse).
`ORSA_PARSE_TIME_CPU_STAT_SUM`	Total CPU time spent on parsing.
`ORSA_RECURSIVE_CALLS_STAT_SUM`	Total number of recursive calls.
`ORSA_SORT_MEMORY_STAT_SUM`	Total number of sorts done in memory.
`ORSA_SORT_DISK_STAT_SUM`	Total number of sorts done on disk.
`ORSA_TABLE_SCAN_LONG_STAT_SUM`	Total number of long table scans.
`ORSA_USER_CALLS_STAT_SUM`	Total number of user calls.
`ORSA_PHYSICAL_READS_STAT_SUM`	Total number of disk reads.
`ORSA_PWII_INSTANCE_ID`	ID of the instance.
`ORSA_OPENS_AND_FETCHES_SUM`	Total number of open and fetches.
`ORSA_SESSIONS_SUM`	Total number of sessions.
`ORSA_PARENT_SHV`	Name of the PL/SQL that ran the SQL statement.
`ORSA_MIN_PARALLEL_DEGREE_MIN`	Minimum parallel degree used to run the statement.
`ORSA_MAX_PARALLEL_DEGREE_MAX`	Maximum parallel degree used to run the statement.
`ORSA_RED_SUM`	SLA breach.
`ORSA_YELLOW_SUM`	SLA near breach.
`ORSA_GREEN_SUM`	SLA okay.
`ORSA_START_BIT_MAP`	Internal use.
`ORSA_INTERPOINT_MODE`	Interpoint mode - OA/SAP/PS.
`ORSA_RECEIVED_TIMESTAMP`	Timestamp at which the row was loaded into the PMDB.
`ORSA_LOG_S_AND_C_WAIT_TIME_SUM`	Total time spent waiting for a log switch and clear waits.
`ORSA_OTHER_LOCK_WAIT_TIME_SUM`	Total time spent waiting for other locks (streams, latches, and internal locks in Oracle).
`ORSA_OTR_INT_LCK_WAIT_STAT_SUM`	Total number of enqueue waits.
`ORSA_RECEIVED_TIMESTAMP`	Timestamp at which the row was loaded into the PMDB.
`ORSA_BUFFER_GETS_SUM`	Total time spent getting buffers.
`ORSA_ROWS_PROCESSED_SUM`	Total number of rows processed.
`ORSA_EXEC_NO_SUM`	Total number of executions.
`ORSA_SQL_ID_MIN`	Minimum Oracle's SQL ID.
`ORSA_HASH_VALUE_MIN`	Minimum Oracle's hash value
`ORSA_PLAN_HASH_VALUE`	Oracle's plan hash value.
`ORSA_END_OF_FETCH_COUNT_SUM`	Number of END OF FETCHs.
`ORSA_VERSION_COUNT_MAX`	Number of statement versions.

PW_ORSS_STATEMENTS_STATS_T

Stores statistics about statement performance per hour.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

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.

The _T table summarizes the data per timeslice.

The _D table summarizes the data per day.

The _W table summarizes the data per week.

The _M table summarizes the data per month.

(N <table_name>) means normalized, the actual name can be retrieved from the <table_name>.

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`	C = Collected G = Gathered M = Manually entered A = Alternative statement
`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.

PS_ORSM_SCHEMA_CHANGE_LOG

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_`

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.

Content

Space Tools

PW_PWII_INSTANCE_ID

PW_ORAS_APPLICATION_STATS_T

PW_ORSA_STMT_APPL_STATS_T

PW_ORSS_STATEMENTS_STATS_T

PW_ORFS_FILES_STATS_T

PW_ORST_STATEMENTS

PW_ORSN_STATEMENT_INFO

PS_ORSM_SCHEMA_CHANGE_LOG

PW_ORSN_STRUCTURE_CHANGE_LOG

PW_ORPS_PW_SIZE

IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal