The Top SQL workspace is used to monitor the Oracle Top SQL statements. All four columns must be specified as filters in the situation or historical collection.
Workspace | Order By value |
---|---|
Top SQL by Elapse Time | elapse_time_delta |
Top SQL by CPU Time | cpu_time_delta |
Top SQL by buffer gets | buffer_gets_delta |
Top SQL by disk reads | disk_reads_delta |
Top SQL by executions | executions_delta |
Top SQL by parse calls | parse_calls_delta |
Top SQL by sharable memory | sharable_mem |
Top SQL by version count | version_count |
Top SQL by cluster wait | clwait_delta |