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

ItemDefault valueChangeable
Collection Interval600Y
Collection Offset100Y
LogNoY
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)
DescriptionSummaryFormatDeltaSupported versionData source
Action
(ACTION)
Name of the action that is specified by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure during data collection--string(32)NoAllV$SESSION.ACTION
Addrhash
(ADDRHASH)
Character string that identifies the SQL statement being executed--string(38)NoAllV$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.
--ulongNoAllV$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.--ulongNoAllAVG(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)NoAllAVG(V$SESSION_EVENT.AVERAGE_WAIT)
Blocking Locks
(BLOCKING_LOCKS)
Number of locks blocking another lock--doubleNoAllCOUNT(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)NoAllV$SESSION.CLIENT_INFO
Client PID
(PROCESS)
Client ID of the OS--string(12)NoAllV$SESSION.PROCESS
Command
(COMMAND)
Command being executed--string(32)NoAllV$SESSION.COMMAND
Fixed Table Sequence
(FIXED_TABLE_SEQUENCE)
Value to be increased each time the session completes a call to the database--doubleNoAllV$SESSION.FIXED_TABLE_SEQUENCE
Locks Held
(LOCKS_HELD)
Number of locks held by the session during data collection--doubleNoAllCOUNT(V$LOCKS) where V$LOCK.LMODE is NOT NULL
Locks Requested
(LOCKS_REQUESTED)
Number of requested locks that the session was not holding--doubleNoAllCOUNT(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)NoAllV$SESSION.LOCKWAIT
Logon Seconds
(LOGON_SECONDS)
Number of seconds since login--ulongNoAllV$SESSION.LOGON_TIME
Logon Time
(LOGON_TIME)
Session connection time--string(20)NoAllV$SESSION.LOGON_TIME
Machine
(MACHINE)
OS machine name--string(64)NoAllV$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)NoAllV$SESSION.MODULE
OS User
(OSUSER)
Client user name of the OS--string(30)NoAllV$SESSION.OSUSER
Open Cursors
(OPEN_CURSORS)
Number of open cursors--ulongNoAllCOUNT(V$OPEN_CURSOR)
Oracle PID
(PID)
Oracle process ID--ulongNoAllV$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)NoAllV$SESSION.SERVER
Program
(PROGRAM)
Program name of OS--string(64)NoAllV$SESSION.PROGRAM
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDS)--string(4)NoAllRemote Monitor Collector
SID
(SID)
Session ID--ulongNoAllV$SESSION.SID
Schema #
(SCHEMA_NUM)
Schema user ID--longNoAllV$SESSION.SCHEMA#
Schema Name
(SCHEMANAME)
Schema user name--string(30)NoAllV$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.--ulongNoAllV$SESSION.SERIAL#
Session Events
(SESSION_EVENTS)
Number of events placed in wait status by the session--shortNoAllCOUNT(V$SESSION_EVENT)
Session Waits
(SESSION_WAITS)
Number of waits caused by the session--ulongNoAllCOUNT(V$SESSION_WAIT)
Sessions Blocked
(SESSIONS_BLOCKED)
Number of sessions blocked by the session--ulongNoAllCOUNT(DBA_WAITERS)
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Status
(STATUS)
Session status. Valid values are ACTIVE, INACTIVE, KILLED, CACHED, and SNIPED.--string(8)NoAllV$SESSION.STATUS
Table Accesses
(TABLE_ACCESSES)
Number of table accesses--doubleNoAllCOUNT(V$ACCESS)
Terminal
(TERMINAL)
Terminal name of the OS--string(16)NoAllV$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.--ulongNoAllSUM(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)NoAllSUM(V$SESSION_EVENT.TIME_WAITED)
Total Timeouts
(TOTAL_TIMEOUTS)
Total number of timeouts for the session events--ulongNoAllSUM(V$SESSION_EVENT.TOTAL_TIMEOUTS)
Total Waits
(TOTAL_WAITS)
Number of waits for all events of the session--doubleNoAllSUM(V$SESSION_EVENT.TOTAL_WAITS)
Transaction Address
(TRANSACTION_ADDRESS)
Address of the transaction state object--string(16)NoAllV$SESSION.TADDR
Transactions
(TRANSACTIONS)
Number of active transactions--ulongNoAllCOUNT(V$TRANSACTION)
Type
(TYPE)
Session type--string(10)NoAllV$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)NoAllV$SESSION.USERNAME
User #
(USER_NUM)
Oracle user ID--longNoAllV$SESSION.USER#
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector