top of page
  • Writer's pictureArun 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

5,842 views

Recent Posts

See All

Imagine an application user gave accidental salary hike of 50% instead of 5% to all employees! To initiate a database point-in-time recovery, we must know the exact time the query was executed against

bottom of page