DBA Easy Control - Database monitoring

Oracle database monitoring tool

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