Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
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 |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.