Session Statistics Summary (PD_PDS2)

Function

The Session Statistics Summary (PD_PDS2) record stores performance data indicating the status (at a specific point in time) of each session and performance indicator of an instance. PFM - RM for Oracle create 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 Offset105Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

PD_PDS2_SID

Lifetime

From the start to the end of a session

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Block Changes/Tran
(BLOCK_CHANGES_PER_TRANSACTION)
Rate at which each transaction executed DML operation--doubleNoAlldb block changes / user commits
Block Visits/Tran
(BLOCK_VISITS_PER_TRANSACTION)
Number of work database read operations executed per transaction--doubleNoAll(db block gets + consistent gets) / user commits
Blocking Locks
(BLOCKING_LOCKS)
Number of locks owned by the session that are blocking another lock
Correct values cannot be collected in this field, and 0 is always displayed.
--doubleNoAllRemote Monitor Collector
Cache Hit %
(CACHE_HIT_PERCENTAGE)
Buffer cache usage--doubleNoAll(1 - (physical reads cache / (consistent gets from cache + db block gets from cache))) * 100
Calls/Tran
(CALLS_PER_TRANSACTION)
Rate at which client requests were executed per transaction--doubleNoAlluser calls / user commits
Changed Block %
(CHANGED_BLOCK_PERCENTAGE)
Percentage indicating the balance between queries and DML in the database application. This value changes according to indexes and application utilization status.--doubleNoAll(db block changes / (block gets + consistent gets)) * 100
Consistent Change %
(CONSISTENT_CHANGE_PERCENTAGE)
Percentage indicating the extents for which the application needed to check the consistency of read operations--doubleNoAll(consistent changes / consistent gets) * 100
Continued Row %
(CONTINUED_ROW_PERCENTAGE)
Percentage ratio of rows obtained that were longer than one block or had been moved--doubleNoAll(table fetch continued row / (table fetch by rowid + table scan rows gotten)) * 100
Deadlocks
(LOCK_DEADLOCKS)
Number of process deadlocks caused by enqueuing (locking) of DML processing--doubleNoAllV$SESSTAT.VALUE
Disk Sorts
(SORTS_DISK)
Number of disk sort operations--doubleNoAllV$SESSTAT.VALUE
Lock Conversions
(LOCK_CONVERSIONS)
Number of enqueues (locks) whose mode was changed (such as from share to lock)--doubleNoAllV$SESSTAT.VALUE
Lock Releases
(LOCK_RELEASES)
Number of times enqueuing (locking) was released. This statistical information is the same as the number of lock requests.--doubleNoAllSUM(V$SESSTAT.VALUE)
Lock Requests
(LOCK_REQUESTS)
Number of times enqueuing (locking) was requested--doubleNoAllV$SESSTAT.VALUE
Lock Timeouts
(LOCK_TIMEOUTS)
Number of times enqueuing (locking) request was not permitted within the specified wait time--doubleNoAllV$SESSTAT.VALUE
Lock Waits
(LOCK_WAITS)
Number of times the lock request was placed in wait status. The number of lock requests that were not placed in wait status is obtained by subtracting the number of enqueued waits from the number of lock requests.--doubleNoAllV$SESSTAT.VALUE
Logical Reads
(LOGICAL_READS)
Sum of the number of logical read operations in read consistency mode and the number of requests to the current copy of block--doubleNoAlldb block gets + consistent gets
Memory Sorts
(SORTS_MEMORY)
Number of sort operations in memory--doubleNoAllV$SESSTAT.VALUE
Non-Index Lookups %
(NON_INDEX_LOOKUPS)
Percentage ratio of full table scans that do not involve caching--doubleNoAll(table scans (long tables) / (table scans (short tables) + table scans (long tables))) * 100
PGA Memory
(PGA_MEMORY)
Size of PGA memory in use during data collection--doubleNoAllV$SESSTAT.VALUE
Physical Writes
(PHYSICAL_WRITES)
Number of physical write operations on the disk by DBWR--doubleNoAllV$SESSTAT.VALUE
Physical Reads
(PHYSICAL_READS)
Number of times a database block was actually read from disk--doubleNoAllV$SESSTAT.VALUE
Program
(PROGRAM)
Program name of OS--string(48)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 PDS2)--string(4)NoAllRemote Monitor Collector
Recursive Calls
(RECURSIVE_CALLS)
Number of user calls processed--doubleNoAllV$SESSTAT.VALUE
Recursive to User Call %
(RECURSIVE_TO_USER_CALL_PERCENTAGE)
Correct values cannot be collected in this field.
Percentage indicating overhead.
--doubleNoAll(recursive calls / user calls) * 100
Redo Log Space Requests
(REDO_LOG_SPACE_REQUESTS)
Number of times a user process waited for space in the REDO log buffer--doubleNoAllV$SESSTAT.VALUE
Redo Log Space Wait %
(REDO_LOG_SPACE_WAIT_PERCENTAGE)
Percentage indicating the memory allocation--doubleNoAll(redo log space requests / redo entries) * 100
Row Source %
(ROW_SOURCE_PERCENTAGE)
Percentage ratio of all rows obtained by full table scan--doubleNoAll(table scan rows gotten / (table fetch by rowid + table scan rows gotten)) * 100
SID
(SID)
Session ID--ulongNoAllV$SESSION.SID
SQL Net Bytes Rcvd
(SQL_NET_BYTES_RECEIVED)
Number of bytes received from clients via SQL*Net--doubleNoAllV$SESSTAT.VALUE
SQL Net Bytes Sent
(SQL_NET_BYTES_SENT)
Number of bytes sent to clients via SQL*Net--doubleNoAllV$SESSTAT.VALUE
Session Cursor Cache Count
(SESSION_CURSOR_CACHE_COUNT)
Total number of references to the cursor--doubleNoAllV$SESSTAT.VALUE
Session Cursor Cache Hit %
(SESSION_CURSOR_CACHE_HIT_PERCENTAGE)
Number of times an access to the session cursor was executed but the session cursor was not found in the cache--doubleNoAll(session cursor cache hits / session cursor cache count) * 100
Session Cursor Cache Hits
(SESSION_CURSOR_CACHE_HITS)
Recorded count of session cursor cache hits--doubleNoAllV$SESSTAT.VALUE
Sort Overflow %
(SORT_OVERFLOW_PERCENTAGE)
Percentage ratio of sort operations using temporary segments--doubleNoAll(sorts (disk) / (sorts (memory) + sorts (disk))) * 100
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Statement CPU
(STATEMENT_CPU)
Total CPU time used by active statements during data collection. To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file.--doubleNoAllV$SESSTAT.VALUE
UGA Memory
(UGA_MEMORY)
Number of session memory segments used--doubleNoAllV$SESSTAT.VALUE
User
(USERNAME)
Oracle user name--string(30)NoAllV$SESSION.USERNAME
User Calls
(USER_CALLS)
Number of user calls processed by active sessions--doubleNoAllV$SESSTAT.VALUE
User Calls / Parse
(USER_CALLS_PER_PARSE)
Percentage indicating how well the application is managing the context area--doubleNoAlluser calls / parse count (total)
User Commits
(USER_COMMITS)
Number of transactions--doubleNoAllV$SESSTAT.VALUE
User Rollback %
(USER_ROLLBACK_PERCENTAGE)
Percentage ratio of application transactions that failed (rolled back)--doubleNoAll(user rollbacks / (user commits + user rollbacks)) * 100
User Rollbacks
(USER_ROLLBACKS)
Number of rollbacks--doubleNoAllV$SESSTAT.VALUE
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
Waiting Locks
(WAITING_LOCKS)
Number of locks owned by another session that this session is waiting for
Correct values cannot be collected in this field, and 0 is always displayed.
--doubleNoAll--
Write %
(WRITE_PERCENTAGE)
Percentage ratio of write operations to all physical I/O operations--doubleNoAll(physical writes / (physical reads + physical writes)) * 100