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