Session Statistics Detail

Overview

The Session Statistics Detail report displays in real-time statistical information about a session. This is a drilldown report.

Storage location

Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/

Record

Session Statistics Summary (PD_PDS2)

Fields

Field nameDescription
Blocking LocksNumber of locks in a session that are blocking other locks
Cache Hit %Buffer cache usage
Disk SortsNumber of disk sort operations
Lock RequestsNumber of lock requests
Lock WaitsNumber of times lock request was placed in wait status
Memory SortsNumber of sort operations in memory
PGA MemorySession's PGA size
Physical ReadsNumber of real read operations on a database block from disk
ProgramProgram name
SIDSession ID
Sort Overflow %Percentage of sort operations using temporary segments
UGA MemorySession's UGA size
UserOracle user name