Oracle DB 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:
 |
Last updated: