• 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

821 views

Recent Posts

See All

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With Citrix XenServer, you must create your own ISO repository to upload ISO files. Create ISO directo

Oracle Home Cloning

Have you ever imagine how easy it would be if you could just clone an existing installation of Oracle Software from one server to another server without performing a fresh installation! You might have

Oracle External Tables

Oracle SQL*Loader engine allows you to query external tables that are stored on flat files. When I say flat files, I literally mean a file that is stored on OS level. Yes, you can query a flat file th