Databases Reference
In-Depth Information
Top SQL Tool
The
Top SQL tool
can identify SQL statements that may be causing performance
problems in the database, such as by using too much CPU or reading blocks from
disk instead of from the cache. Even if the SQL command itself does not use
many resources, it may still be a candidate for tuning if it is executed hundreds
of times an hour!
The Top SQL tool is available in Oracle9
i
through the Oracle Enterprise
Manager (OEM) console, via the Diagnostics Pack pull-out, as shown below.
Top SQL tool
A GUI-based Oracle tool that can identify
SQL statements that may be consuming
too many system resources and therefore
may be good candidates for tuning.
The Top SQL tool shows a number of statistics for each SQL command exe-
cuted, such as disk reads, buffer reads (data is already available in the buffer
cache and does not need a read from disk), CPU time used, and the number of
executions. The following illustration shows an example of a Top SQL window.
