Session Statistics Detail(4.0)
- Organization of this page
Overview
The Session Statistics Detail(4.0) report displays in real-time statistical information about a session. This is a drilldown report.
Storage location
Reports/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 |