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

Was this article helpful?

Related Articles

Leave a Comment