Oracle database monitoring tool
Home Features Screenshots Download Activate Contacts
 
Database monitoring
 

You can start monitoring a database in minutes. You do not need to install any agents on database hosts. Monitoring options include:

 

- Creating user-specific SQL or PL/SQL metrics with warning notification

- Execution of user-specific OS scripts on Windows and Unix (ssh) platform, output control

- Creating customized SQL reports with email notification

- Saving result of metrics and scripts execution and drawing customized chart diagrams

- Individual email notifications about problems

- Dynamic visual indication of problems in the console

- Ability to process a thread of warnings by a team


If necessary, you can easily add your own monitoring scripts to the system, accept messages from other monitoring systems and configure the delivery of reports and notifications.

 
Monitoring specification
 

 

 Monitoring option Interval (min) Alarmís conditions (modifiable) SubSystem
     
 Common checks      

 - Invalid objects
 - Nologging objects
 - Unusable indexes
 - Unusable index partitions
 - Unusable index subpartitions
 - Datafiles need recovery
 - Max datafiles threshold

10

 Unusable indexes > 0
 Unusable index partitions > 0
 Unusable index subpartitions > 0
 Datafiles need recovery > 0
 Count of datafiles/db_files > 90%
 

PL/SQL Metric
     
 Alert Log monitoring*      

 - internal errors
 - snapshot too old
 - error on execute of jobs
 - data block corruptions
 - memory errors

20

 ORA-00600 (internal error)
 ORA-07445 (internal error)
 ORA-01555 (snapshot too old)
 ORA-12012 (error on execute of job)
 ORA-01578 (data block corrupted)
 ORA-0403% (memory problem)

PL/SQL Metric
     
 CPU Load**      

 - CPU Count
 - CPU Load

10

 CPU load > 80% of CPU count
 

PL/SQL Metric
     
 Event Waits**      

 - User I/O
 - System I/O
 - Concurrency
 - Application
 - Administration
 - Network
 - Commit
 - Configuration
 - Other

10

 Concurrency ratio > 90%
 Commit ratio > 90%

 

PL/SQL Metric
     
 Sessions Activity      
 - Sessions
 - Active Sessions
 - Processes
 - Sessions Limit
 - Processes Limit

10

 - Sessions Limit Usage > 90%.
 - Processes Limit Usage > 90%
 
PL/SQL Metric
     
 Transactions      
 - Commits/sec
 - Rollbacks/sec
 - Transactions/sec
 - Rollback ratio

30

 Rollback ratio > 50% of all transactions PL/SQL Metric
     
 Executions      

 - User Calls/sec
 - Executions/sec
 - Parses/sec
 - Hard Parses/sec
 - Hard Parses ratio
 - Logons/sec
 - Recursive calls

30

 Hard Parse ratio > 50% of all parses PL/SQL Metric
     
 I/O Statistics      

 - Logical reads/sec
 - Physical reads/sec
 - Physical writes/sec
 - Buffer cache hit ratio

30

 Buffer cache hit ratio < 50% PL/SQL Metric
     
UNDO Usage      

 - UNDO size
 - UNDO used
 - UNDO free and expired
 - UNDO usage
 - UNDO active
 - UNDO expired
 - UNDO unexpired

10

 UNDO Usage > 95% PL/SQL Metric
     
 Jobs Delay      

10

 Jobs not started during 10min after
 scheduled time
PL/SQL Metric
     
 Archived Logs Area*      
 - Count of archived logs
 (all destinations including FRA)
 

10

 Individual threshold depend on
 frequency of backup procedure
PL/SQL Metric
     
 Standby Delay*      

 - current log
 - archived log
 - applied log
 - log gap

10

 Standby delay more than 10 archived
 logs
PL/SQL Metric
     
 Free space in tablespaces      

60

 - Default threshold 90%
 - Individual threshold for big
 tablespaces (Mb)
 
Repository job
     
 Segment can't extend      
 - Not free extent with right size
 in tablespace
 - Max extents for segment
 reached

60

 Segment canít extend Repository job
     
 Configurations checks      
 - Users have proper DEFAULT
 tablespace
 - Users have proper TEMPORARY
 tablespace

60

 Violations Repository job
     
 Free partitions in partitioned
 tables
     

60

 Individual thresholds Repository job
     
 Grant Expired (marked to
 revoke)
     

 - SYSTEM Privilege
 - OBJECT Privilege
 - ROLE

60

 Individual notifications

 
Repository job
     
 Host runqueue      

10

 Individual threshold OS Metric
     
 Used space in archive area      

15

 Used space > 75% OS Metric
     
 Used space for dump files      

30

 Used space > 85% OS Metric
     
 Used space in Oracle home
 area
     

30

 Used space > 85% OS Metric
     
 Tnsping check      

10

 Listener replay more than 500ms OS Metric

* For database versions 9.x and higher
** For database versions 10.x and higher

 

www.dbaeasy.com   Copyright © Alexey Brysov 2015 All Rights Reserved.