Database Reference
In-Depth Information
The preceding information shows the object name, the object type, and the line number. This data can be used
to quickly identify where the problem is in the code. The SQL Details Activity tab, shown in Figure
9-16
, offers a
SQL-specific view of Top Activity data, eliminating all other SQL waits and SQL executions, other than the one SQL ID
in question. The grayed area can be moved anywhere within the timeline shown to highlight waits within the SQL activity.
As this is SQL activity vs. session activity, the sessions executing the SQL in the Details page are shown at the bottom,
along with percentage of activity, the session ID (SID) if the session is part of a parallel process, the QC SID (including
all parallel sessions for the user executing the SQL), the program the SQL is part of, and whether there is a plan hash
value that the SQL is identified with.
Figure 9-16.
Activity tab of the SQL Details page
You can execute an HTML version of an AWR or ASH report from this pane to further investigate the activity and
database performance by clicking a SQL ID and entering the interface for the SQL Details page.
SQL Statistics
The first tab in the SQL Details page, Statistics, contains SQL statistics data. This view, shown in Figure
9-17
, gives
active session information, breaking down the activity by waits, time, elapsed time (database time vs. CPU time),
execution statistics, and cursor statistics.
Figure 9-17.
Statistics activity in the SQL Details page
