DBA > Job Interview Questions > Oracle DBA Checklist

Oracle DBA Checklist - -Verify free space in tab

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - -Verify free space in tablespaces - Daily Procedures

Verify success of database backup
Verify success of database archiving to tape
Verify enough resources for acceptable performance
Verify free space in tablespaces.
For each instance, verify that enough free space exists in each tablespace to handle the day's expected growth. As of <date>, the minimum free space for <repeat for each tablespace>: [ < tablespace > is < amount > ]. When incoming data is stable, and average daily growth can be calculated, then the minimum free space should be at least <time to order, get, and install more disks> days' data growth.
a) Go to each instance, run free.sql to check free mb in tablespaces. Compare to the minimum free MB for that tablespace. Note any low-space conditions and correct.
b) Go to each instance, run space.sql to check percentage free in tablespaces. Compare to the minimum percent free for that tablespace. Note any low-space conditions and correct.

(Continued on next question...)

Other Job Interview Questions