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_ | |
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_SUM 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_SUM 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_ROLLBCK_SEG_WAIT_TIME_SUM Total time spent waiting for a rollback segment.
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