The following Top SQL sections sort the
SQL statements with the top resource usage in multiple ways, as indicated by
their titles:
- SQL ordered by Elapsed Time
- SQL ordered by CPU Time
- SQL ordered by Gets
- SQL ordered by Reads
- SQL ordered by Executions
- SQL ordered by Parse Calls
- SQL ordered by Sharable Memory
- SQL ordered by Version Count
These sorts allow you to find the
troublesome SQL statement. You can also view the Complete List of SQL Text
section to view the entire SQL text. In this example, a single SQL statement is
responsible for almost all of the instance activity.
No comments:
Post a Comment