Oracle DB SQL statements monitoring

This feature comes with XorMon v2.4.0.
Anyone willing to test it? Contact us at [email protected].

XorMon gets every 5 minutes TOP 25 SQL jobs as per CPU spent time and presenting them.
To get in place, you need to enhance user rights as per installation docu, search a note "2.4.0".

Graph types

  • TOP 50 as a table
  • Avg per execution
  • Load
  • Execution
  • IO
  • Row

Examples

TOP 50:
Oracle DB monitoring SQL execution: TOP 50

Execution:
Oracle DB monitoring SQL execution: Execution

AVG per Execution:
Oracle DB monitoring SQL execution: AVG per Execution

IO:
Oracle DB monitoring SQL execution: IO

SQL text:
Oracle DB monitoring SQL execution: SQL text