Oracle DB monitoring

XorMon v2.4.0 brings huge enhancements for Oracle Database monitoring
To get new features in place, you need to enhance user rights as per installation docu, search a note "2.4.0".

New features

  • ASM monitoring include topology
  • SQL statements
  • 70% of original metrics saving 1 minute samples instead of 5 minutes how it was before
  • Most of queries are adjusted and optimized, monitoring impact is much lower despite of many new queries
  • Latency graphs under Instances was completelly re-build
  • Alert history

New subsystems

  • ASM diskgroup
  • ASM disk
  • Session
    • Sessions
    • Blocking
    • Long Running
    • Longest Block
  • Service
    • Sessions
    • Active / Blocked
    • User Calls
    • Transaction
    • Execustion
    • Cursor
    • Logical Read
    • Physical IO
    • Redo
    • DB Time
    • AAS by Wait Time
  • SQL Query
    • User Transaction
    • User Commit
    • Open Cursor
    • Current Open Cursor
    • Hard Parse
    • Execution
  • Waitclass
    • Wait Time
    • Wait Time (foreground)
    • Wait
    • Avg Wait
  • DataGuard
    • Configuration
    • Destination
    • Apply Lag
    • Gap

Examples

Alert history:
Oracle DB monitoring: Alert history

DataGuard Gap:
Oracle DB monitoring: DataGuard Gap

SQL Query:
Oracle DB monitoring: SQL Query

Service Session:
Oracle DB monitoring: Service Session

Service Transaction:
Oracle DB monitoring: Service Transaction

Wait Class: Wait Time:
Oracle DB monitoring: Wait Class: Wait Time

Sessions:
Oracle DB monitoring: Sessions

Session: Long Running:
Oracle DB monitoring: Session: Long Running