![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
Function
The Session Detail (PD_PDS) record stores the performance data indicating the status (at a specific point in time) of sessions. PFM - RM for Oracle creates one record for each session in an instance. This is a multi-instance record.
If you cannot view the performance data in this record, create Oracle's static data dictionary view DBA_WAITERS. To create the static dictionary view DBA_WAITERS, you need to execute the CATBLOCK.SQL script that is provided by Oracle.
Default and changeable values
| Item | Default value | Changeable |
|---|---|---|
| Collection Interval | 600 | Y |
| Collection Offset | 100 | Y |
| Log | No | Y |
| LOGIF | (Blank) | Y |
ODBC key fields
Lifetime
From the start to the end of a session
Record size
Fields
| PFM - View name (PFM - Manager name) |
Description | Summary | Format | Delta | Supported version | Data source |
|---|---|---|---|---|---|---|
| Action (ACTION) |
Name of the action that is specified by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure during data collection | -- | string(32) | No | All | V$SESSION.ACTION |
| Addrhash (ADDRHASH) |
Character string that identifies the SQL statement being executed | -- | string(38) | No | All | V$SESSION.SQL_ADDRESS + V$SESSION.SQL_HASH_VALUE |
| Auditing SID (AUDSID) |
Auditing session ID. The value of this field is -1 when Oracle Database 10g is being monitored or when the value of the User field is SYS. |
-- | ulong | No | All | V$SESSION.AUDSID |
| Avg Wait (AVERAGE_WAIT) |
Average time of all events that the session is waiting for. To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file. | -- | ulong | No | All | AVG(V$SESSION_EVENT.AVERAGE_WAIT) |
| Avg Wait String (AVERAGE_WAIT_STRING) |
Average time (character string) of all events that the session is waiting for. To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file. | -- | string(20) | No | All | AVG(V$SESSION_EVENT.AVERAGE_WAIT) |
| Blocking Locks (BLOCKING_LOCKS) |
Number of locks blocking another lock | -- | double | No | All | COUNT(V$LOCK) where V$LOCK.BLOCK > 0 |
| Client Info (CLIENT_INFO) |
Information specified by calling the DBMS_APPLICATION_INFO.SET_CLIE NT_INFO procedure | -- | string(64) | No | All | V$SESSION.CLIENT_INFO |
| Client PID (PROCESS) |
Client ID of the OS | -- | string(12) | No | All | V$SESSION.PROCESS |
| Command (COMMAND) |
Command being executed | -- | string(32) | No | All | V$SESSION.COMMAND |
| Fixed Table Sequence (FIXED_TABLE_SEQUENCE) |
Value to be increased each time the session completes a call to the database | -- | double | No | All | V$SESSION.FIXED_TABLE_SEQUENCE |
| Locks Held (LOCKS_HELD) |
Number of locks held by the session during data collection | -- | double | No | All | COUNT(V$LOCKS) where V$LOCK.LMODE is NOT NULL |
| Locks Requested (LOCKS_REQUESTED) |
Number of requested locks that the session was not holding | -- | double | No | All | COUNT(V$LOCKS) where V$LOCK.LMODE is NULL |
| Lockwait (LOCKWAIT) |
Address of the lock the session is waiting for. If there is no such lock, the value is null. | -- | string(16) | No | All | V$SESSION.LOCKWAIT |
| Logon Seconds (LOGON_SECONDS) |
Number of seconds since login | -- | ulong | No | All | V$SESSION.LOGON_TIME |
| Logon Time (LOGON_TIME) |
Session connection time | -- | string(20) | No | All | V$SESSION.LOGON_TIME |
| Machine (MACHINE) |
OS machine name | -- | string(64) | No | All | V$SESSION.MACHINE |
| Module (MODULE) |
Name of the module being executed that is specified by calling the DBMS_APPLICATION_INFO.SET_MODULE during data collection | -- | string(48) | No | All | V$SESSION.MODULE |
| OS User (OSUSER) |
Client user name of the OS | -- | string(30) | No | All | V$SESSION.OSUSER |
| Open Cursors (OPEN_CURSORS) |
Number of open cursors | -- | ulong | No | All | COUNT(V$OPEN_CURSOR) |
| Oracle PID (PID) |
Oracle process ID | -- | ulong | No | All | V$PROCESS.PID where V$SESSION.PADDR = V$PROCESS.ADDR |
| Oracle Server (SERVER) |
Oracle server type. Valid values are DEDICATED, NONE, PSEUDO, and SHARED. | -- | string(9) | No | All | V$SESSION.SERVER |
| Program (PROGRAM) |
Program name of OS | -- | string(64) | No | All | V$SESSION.PROGRAM |
| Record Time (RECORD_TIME) |
Collection termination time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
| Record Type (INPUT_RECORD_TYPE) |
Record name (always PDS) | -- | string(4) | No | All | Remote Monitor Collector |
| SID (SID) |
Session ID | -- | ulong | No | All | V$SESSION.SID |
| Schema # (SCHEMA_NUM) |
Schema user ID | -- | long | No | All | V$SESSION.SCHEMA# |
| Schema Name (SCHEMANAME) |
Schema user name | -- | string(30) | No | All | V$SESSION.SCHEMANAME |
| Serial # (SERIAL_NUM) |
Session serial number that identifies the session object. The session serial number guarantees that a session-level command is applied to the correct session object even when one session ends and another session with the same session ID starts. | -- | ulong | No | All | V$SESSION.SERIAL# |
| Session Events (SESSION_EVENTS) |
Number of events placed in wait status by the session | -- | short | No | All | COUNT(V$SESSION_EVENT) |
| Session Waits (SESSION_WAITS) |
Number of waits caused by the session | -- | ulong | No | All | COUNT(V$SESSION_WAIT) |
| Sessions Blocked (SESSIONS_BLOCKED) |
Number of sessions blocked by the session | -- | ulong | No | All | COUNT(DBA_WAITERS) |
| Start Time (START_TIME) |
Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
| Status (STATUS) |
Session status. Valid values are ACTIVE, INACTIVE, KILLED, CACHED, and SNIPED. | -- | string(8) | No | All | V$SESSION.STATUS |
| Table Accesses (TABLE_ACCESSES) |
Number of table accesses | -- | double | No | All | COUNT(V$ACCESS) |
| Terminal (TERMINAL) |
Terminal name of the OS | -- | string(16) | No | All | V$SESSION.TERMINAL |
| Time Waited (TIME_WAITED) |
Total length of time the session waited for all events. To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file. | -- | ulong | No | All | SUM(V$SESSION_EVENT.TIME_WAITED) |
| Time Waited String (TIME_WAITED_STRING) |
Total length of time (character string) the session waited for all events To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file. | -- | string(20) | No | All | SUM(V$SESSION_EVENT.TIME_WAITED) |
| Total Timeouts (TOTAL_TIMEOUTS) |
Total number of timeouts for the session events | -- | ulong | No | All | SUM(V$SESSION_EVENT.TOTAL_TIMEOUTS) |
| Total Waits (TOTAL_WAITS) |
Number of waits for all events of the session | -- | double | No | All | SUM(V$SESSION_EVENT.TOTAL_WAITS) |
| Transaction Address (TRANSACTION_ADDRESS) |
Address of the transaction state object | -- | string(16) | No | All | V$SESSION.TADDR |
| Transactions (TRANSACTIONS) |
Number of active transactions | -- | ulong | No | All | COUNT(V$TRANSACTION) |
| Type (TYPE) |
Session type | -- | string(10) | No | All | V$SESSION.TYPE |
| User (USERNAME) |
Oracle user name This field always includes a record for which NULL is set as information for the SYS user. Since null cannot be specified conditionally for connections from users other than special user A, use the User # field to specify the following conditional expressions: User<> "A" AND User #<>"0" |
-- | string(30) | No | All | V$SESSION.USERNAME |
| User # (USER_NUM) |
Oracle user ID | -- | long | No | All | V$SESSION.USER# |
| VA DeviceID (VADEVICEID) |
Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.