Step 2: Use Database Metrics (DB Ops Console)
Navigate to:
Retail Home -> Application Navigator -> DB Ops Console -> Database Metrics
Table 23-1 Key Metrics to Watch
| Metric | What It Indicates |
|---|---|
| CPU Utilization | High = heavy load; may align with performance drop |
| Storage Utilization | If near capacity, could be causing issues |
| Session Count | Spike in active sessions = concurrency issue |
| Execute Count | High = heavy workload; baseline expected volume |
| Running Statements | Indicates how many statements are using resources |
| Queued Statements | Indicates backlog due to contention |
| APEX Load Time | Perceived slowness for end users |
| APEX Page Events | Intensity of user interaction with APEX apps |
Look at trends using 1-minute or 5-minute intervals. Spikes or sustained elevation may confirm a user-reported slowdown.