Session Detail (PD_PDS)
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 |