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.