• 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

615 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir