Dba's have to control database performance and generated logs daily, weekly and monthly. These controls provide database health check. You could control all Oracle database versions and other data types in these ten steps.
- All Database instances Running & Up Control
- All Database Services ( listener, crs, emconsole, data guard status ) Running & Up Control
- Check Current Session Or Active Session Count
- Check the alert log for an error
- Check tablespace usage and free space for Data and index tablespaces
- Check the Top session using more Physical I/O
- Check the number of log switch per hour
- How much redo generated last 24 hour
- Check any session blocking other sessions
- Check disk spaces , archive directories, utl file directories, oracle home.
Hiç yorum yok:
Yorum Gönder