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:
DataGuard Gap:
SQL Query:
Service Session:
Service Transaction:
Wait Class: Wait Time:
Sessions:
Session: Long Running: