15 Nisan 2013 Pazartesi

DB HEALTH CHECK CONTROLS 2- WEEKLY


Dba can check all test and development databases weekly.  These controls enclose open source databases, some commands oracle databases.

  1. Objects  fragmentation
  2. Size of tables and indexes
  3. Check for block corruption
  4. Disk usages
  5. Tablespace usages
  6. Check the cpu ratio
  7. Check open cursor not reaching the max limit
  8. Check the alert log and litener log
  9. Check the dba_jobs
  10. Check the crontab
  11. Check expired/locked  accounts


Hiç yorum yok: