Database Maintenance & Monitoring (DBMM): Complete automation of Oracle database. DBMM is an easiest, quickest and robust solution for complete automation of a new Oracle database setup under any unix or linux OS. This can be easily customized to client’s need with little to no changes required at all. With DBMM DBAs can receive automatic alerts in case of a problem through email or phone (based on configuration). It allows DBAs to check the status of a number of important database services on an hourly basis and keeps a historical log on server file-systems. DBMM provides key features such as: monitoring, backup, maintenance, performance monitoring.
For Questions or Information:
Monitoring
Monitor alert log at regular interval
Database Availability
Listener Availability
Disk Free Space
Tablespace Free Space
Replication status
Streams Monitoring
Top session/hang-over session
Data Guard monitoring (Primary, physical standby and logical standby database)
Backup
Cold backup
Hot backup
Rman backup
Logical backup using Export and Import
Logical backup using Data Pump
Will purge the old backup based on retention and generation parameter
Maintenance
Purge rman backup set
Delete expires archive log
Synchronize rman catalog
Register database in catalog
Unregister database in catalog
Analyze database to collect statistics
Reorganize the schema at regular interval
Purges (bdump, cdump, udump trace files)
Purges (bdump, cdump, udump trace files based on retention parameter set)
Performance Monitoring
Data Buffer Cache
Library Cache
Data Dictionary Cache
Log Buffer Cache
Sorts/Disk vs Sorts/Memory
Poorly Performing SQL
System wait statistics