Monitoring SQL
The Average Active Sessions by drop-down contains a SQL fly-out with the following common views:
- SQL ID
- Top Level SQL ID
- SQL Force Matching Signature
- SQL Plan Hash Value
- SQL Full Plan Hash Value
- SQL Plan Operation
- SQL Plan Operation Line
- SQL Opcode
- Top Level SQL Opcode
To monitor SQL:
-
Access the Performance Hub page, as explained in "Monitoring User Activity".
-
Click on the drop-down in Average Active Sessions by, mouse onto SQL, and select the desired view from the fly-out.
- SQL ID
- Top Level SQL ID
- SQL Force Matching Signature
- SQL Plan Hash Value
- SQL Full Plan Hash Value
- SQL Plan Operation
- SQL Plan Operation Line
- SQL Opcode
- Top Level SQL Opcode
Graphs, tables, and information on the page are updated to reflect the selected criteria.