Oracle Performance (ORACLE_PERFORMANCE)
Represents the performance parameters for the instance. You can also run reports detailing buffer cache contents and locks for the instance.
ORACLE_PERFORMANCE
is available once the instance has been configured, and once the PERFORMANCE category has been selected to be active.
This application class or category is not enabled for monitoring by default; it must be enabled before the parameters will be populated.
The ORACLE_PERFORMANCE icon is labelled PERFORMANCE.
Application class attributes
Item | Description |
---|---|
Active | Yes |
Created by | Discovery |
Parent class | ORACLE_INSTANCE |
Child class | None |
Attributes (parameters)
The following attributes are available for this monitor type:
- Average Minutes Between Checkpoints (ChkpntRate)
- Background Checkpoint (BGChkpntRate)
- Block Changes (BlkChgRate)
- Block Gets (BlkGetRate)
- Calls (CallRate)
- Consistent Changes per Consistent Gets (ConsChgRatio)
- Current Transactions (CurrentTrans)
- Database Writer Average Buffers Scanned (DBWRAvgBuffScanned)
- Database Writer Average Scan Depth (DBWRAvgScanDepth)
- Database Writer Buffers Scanned (DBWRBuffScanned)
- Database Writer Checkpoints (DBWRCheckpoints)
- Database Writer Cross Instance Writes (DBWRCrossInstWrites)
- Database Writer Free Buffers Found (DBWRFreeBuffFound)
- Database Writer LRU Scans (DBWRLRUScans)
- Database Writer Make Free Requests (DBWRMakeFreeRequests)
- Database Writer Reusable Buffers (DBWRReusableBuff)
- Database Writer Summed Scan Depth (DBWRSummedScanDepth)
- Database Writer Timeouts (DBWRTimeouts)
- Enqueue Deadlocks (EnqDeadlocks)
- Enqueue Conversions (EnqConversions)
- Disk Sorts (DiskSorts)
- Data Manipulation Locks (DMLLocks)
- Enqueue Requests (EnqRequests)
- Enqueue Releases (EnqReleases)
- EnqTimeouts (EnqTimeouts)
- Enqueue Waits (EnqWaits)
- Statement Execution (ExecRate)
- Average Lock Acquired Wait Time (LockAvgWait)
- Lock Requests that Wait (LockWaitRatio)
- Response Sql Execution Time (ResponseSqlTime)
- Response Execution Time (ResponseExecTime)
- Transactions (TransRate)
- Rollback Segment Entry Waits (RSEntWaits)
- Rollback Header Waits to Gets Ratio (RSHdrWaits)
- Rollback Transaction Ratio (UserRBRatio)
- UserCallRate
- Average Row Sorts per All Sorts (RowsPerSort)
- Average Disk Sorts (DiskSortRate)
Was this page helpful? Yes No
Submitting...
Thank you
Comments
Log in or register to comment.