top_sql
Identify top SQL statements by elapsed time in the last N minutes to diagnose recent performance issues from Oracle database.
Instructions
Top SQL by elapsed time from v$sql within the last N minutes.
Useful for "what's been slow recently?" investigations from Claude Desktop.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| window_minutes | No | ||
| limit | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |