top of page
Oracle Database Health Check
Ensure optimal performance with a comprehensive Oracle database health check.
Daily DB Health Checks
Below are daily checks which are to be performed by a DBA:
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
bottom of page