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_RECIEVED_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