get_wait_events
List current Oracle wait events from V$SESSION_WAIT, with optional SID and wait class filters to diagnose session performance bottlenecks.
Instructions
List current wait events from V$SESSION_WAIT. Optional sid filter and wait_class filter (e.g. 'Application','Concurrency','User I/O').
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sid | No | Optional session id (SID) filter. | |
| waitClass | No | Optional wait class filter (e.g. 'User I/O', 'Application'). |