Oracle DB Monitoring
 |
XorMon obtains data through SQL (SQL*Plus). Oracle client must be installed on XorMon server.
Monitoring implementation does not require any Oracle licensed features like Oracle Diagnostics Pack or Oracle Tuning Pack .
XorMon requires a database user with the following view only permissions to collect monitoring data:
- create session
- select rights on specific sys.* tables
Supported databases
- RAC
- Standalone
- Multitenant
- DataGuard
Collected Metrics
| Subsystem | Metric | Standalone | RAC | Multitenant | |
|---|---|---|---|---|---|
| Health status | yes | yes | CDB | PDB | |
| Configuration | Overall | yes | yes | yes | yes |
| SGA | yes | yes | yes | yes | |
| Tablespace size | yes | yes | yes | yes | |
| Installed DB components | yes | yes | yes | yes | |
| Upgrade, Downgrade info | yes | yes | yes | yes | |
| PSU, patches | yes | yes | yes | yes | |
| Interconnect | Traffic MB/sec | yes | |||
| Configuration | yes | ||||
| Datafiles | Performance stats (table) | yes | yes | yes | |
| Global Cache | get time | yes | |||
| block a sec | yes | ||||
| block 2 way/3 way | yes | ||||
| block bussy/congest, grant congest | yes | ||||
| block lost, blocks corrupted/lost, retry | yes | ||||
| split, bussy release, disk read, multiblock request, grant busy, busy acquire | yes | ||||
| remaster | yes | ||||
| CPU | Host CPU usage | yes | yes | yes | |
| CPU core Per Sec | yes | yes | yes | ||
| CPU core Per Txn | yes | yes | yes | ||
| IO | Total | yes | yes | yes | yes |
| Physical Read | yes | yes | yes | yes | |
| Physical Write | yes | yes | yes | yes | |
| Data | Total | yes | yes | yes | yes |
| Redo | yes | yes | yes | yes | |
| Physical Read | yes | yes | yes | yes | |
| Physical Write | yes | yes | yes | yes | |
| SGA data | Block Changes | yes | yes | yes | |
| Logical Read | yes | yes | yes | ||
| Session | Session | yes | yes | yes | |
| Current logons count | yes | yes | yes | ||
| Active serial | yes | yes | |||
| Logons per sec | yes | yes | |||
| Active paralel | yes | yes | |||
| Avg active | yes | yes | |||
| Blocking | yes | yes | |||
| Long Running | yes | yes | |||
| Longest Block | yes | yes | |||
| Network | MB/sec | yes | yes | yes | yes |
| Ratio | Buffer Cache Hit | yes | yes | yes | yes |
| PGA Cache Hit | yes | yes | yes | yes | |
| Memory Sorts | yes | yes | yes | yes | |
| Soft Parse | yes | yes | yes | yes | |
| CPU Time | yes | yes | yes | yes | |
| Wait Time | yes | yes | yes | yes | |
| Latency | DB files read | yes | yes | yes | yes |
| DB files write | yes | yes | yes | yes | |
| LOG files write | yes | yes | yes | yes | |
| Flashback latency | yes | yes | yes | yes | |
| Wait class | Average wait FG | yes | yes | yes | yes |
| Average wait | yes | yes | yes | yes | |
| Wait Time | yes | yes | yes | yes | |
| Wait Time (foreground) | yes | yes | yes | yes | |
| Wait | yes | yes | yes | yes | |
| Services | Physical Writes | yes | yes | yes | yes |
| Physical Reads | yes | yes | yes | yes | |
| Sessions | yes | yes | yes | yes | |
| Active / Blocked | yes | yes | yes | yes | |
| User Call | yes | yes | yes | yes | |
| Transaction | yes | yes | yes | yes | |
| Execustion | yes | yes | yes | yes | |
| Cursor | yes | yes | yes | yes | |
| Logical Read | yes | yes | yes | yes | |
| Physical IO | yes | yes | yes | yes | |
| Redo | yes | yes | yes | yes | |
| DB Time | yes | yes | yes | yes | |
| AAS by Wait Time | yes | yes | yes | yes | |
| ASM Disk group | Configuration | yes | yes | yes | yes |
| Used in % | yes | yes | yes | yes | |
| Used in GiB | yes | yes | yes | yes | |
| Free in GiB | yes | yes | yes | yes | |
| Usable after a disk failure | yes | yes | yes | yes | |
| Offline disks | yes | yes | yes | yes | |
| ASM Disk | Configuration | yes | yes | yes | yes |
| Used in % | yes | yes | yes | yes | |
| Used in GiB | yes | yes | yes | yes | |
| Free in GiB | yes | yes | yes | yes | |
| Total IOPS | yes | yes | yes | yes | |
| Read IOPS | yes | yes | yes | yes | |
| Write IOPS | yes | yes | yes | yes | |
| Data in MB/sec | yes | yes | yes | yes | |
| Latency in mili sec | yes | yes | yes | yes | |
| Hot/Cold IOPS | yes | yes | yes | yes | |
| Hot/Cold MB/sec | yes | yes | yes | yes | |
| IO Errors | yes | yes | yes | yes | |
| Data Guard | Configuration | yes | yes | yes | yes |
| Destination | yes | yes | yes | yes | |
| Apply Lag | yes | yes | yes | yes | |
| Gap | yes | yes | yes | yes | |
| SQL Query | User Transaction | yes | yes | yes | yes |
| User Commit | yes | yes | yes | yes | |
| Open Cursor | yes | yes | yes | yes | |
| Current Open Cursor | yes | yes | yes | yes | |
| Hard Parse | yes | yes | yes | yes | |
| Execution | yes | yes | yes | yes | |