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 |