• Arun Kumar

Oracle Database Health Check

Daily DB Health Checks


Below are daily checks which are to be performed by a DBA:

  1. Check all instance, listener are up and running

SELECT NAME, OPEN_MODE FROM V$DATABASE;

LSNRCTL STATUS;

2. Check ALERT log errors

SHOW PARAMETER BACKGROUND_DUMP_DEST

3. Capacity planning – Tablespace space checking&Archive log space checking

SELECT TABLESPACE_NAME, SUM(BYTES/1024/1024) 

FROM DBA_FREE_SPACE

GROUP BY TABLESPACE_NAME

4. Verify success of backup & archiving

5. AWR report twice a day and compare the stats

6. Troubleshoot any issue reported

7. Database refreshes if made on daily basis


Weekly DB Health Checks

  • Statistics gathering

  • Index rebuild if needed (ALTER INDEX emp_nameREBUILD 😉

  • Database health check

  • Any other scheduled tasks

1,637 views

Recent Posts

See All