Database Reference
In-Depth Information
Figure 9-29.
The drop-down menu options for the ASH Analytics Wait Class
SQL can be broken down in many ways within the ASH Analytics Activity view. The options are shown in
Table
9-2
. Depending on the needs of the administrator, the order of the presentation can be changed.
Table 9-2.
The Wait Class Options and Suboptions
Option
Suboptions
SQL
SQL ID
Top Level SQL ID
SQL Force Matching Signature
SQL Plan Hash Value
SQL Plan Operation
SQL Plan Operation Line
SQL Opcode
Top Level SQL Opcode
PL/SQL
PL/SQL
Top Level PL/SQL
Resource Consumption
Wait Class
Wait Event
Object
Blocking Session
Session Identifiers
Instance
Service
User Session
Parallel Process
User ID
Program
Session Type
Session Attributes
Consumer Group
Module
Action
