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 name | Description |
---|---|
Blocking Locks | Number of locks in a session that are blocking other locks |
Cache Hit % | Buffer cache usage |
Disk Sorts | Number of disk sort operations |
Lock Requests | Number of lock requests |
Lock Waits | Number of times lock request was placed in wait status |
Memory Sorts | Number of sort operations in memory |
PGA Memory | Session's PGA size |
Physical Reads | Number of real read operations on a database block from disk |
Program | Program name |
SID | Session ID |
Sort Overflow % | Percentage of sort operations using temporary segments |
UGA Memory | Session's UGA size |
User | Oracle user name |