Monitoring SQL

The Average Active Sessions by drop-down contains a SQL fly-out with the following common views:

To monitor SQL:

  1. Access the Performance Hub page, as explained in “Monitoring User Activity”.

  2. 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.

See Also: