Session Detail (PD_PDS)

Collection Interval

600

Y

Collection Offset

100

Y

Log

No

Y

LOGIF

(Blank)

Y

Over 10 Sec Collection Time

No

N

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. In centiseconds (1/100 of a second).

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. In seconds.

To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file.

--

string(30)

No

All

AVG(V$SESSION_EVENT.AVERAGE_WAIT) / 100

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 or command number

--

string(32)

No

All

V$SESSION.COMMAND

Container ID

(CONTAINER_ID)

The ID of the container to which this session belongs.

This field is valid if the monitoring target is Oracle Database 12c R2 or later in a CDB configuration.

Otherwise, the value is 0.

--

word

No

Oracle 12c R2 or later

V$SESSION.CON_ID

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^#11

--

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

Agent Collector

Record Type

(INPUT_RECORD_TYPE)

Record name (always PDS)

--

string(4)

No

All

Agent 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^#11

--

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

Agent 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^#11

--

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. In centiseconds (1/100 of a second).

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. In seconds.

To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file.

--

string(30)

No

All

SUM(V$SESSION_EVENT.TIME_WAITED) / 100

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^#11

--

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#