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