Oracle DataBase Administrator Checklist

Oracle DataBase Administrator Checklist




Weekly Procedures



A. Look for objects that break rules
For each object-creation policy (naming convention, storage parameters, etc.) have an automated check to verify that the policy is being followed.


1. Every object in a given tablespace should have the exact same size for NEXT_EXTENT, which should match the tablespace default for NEXT_EXTENT. As of 12/14/98, default NEXT_EXTENT for DATAHI is 1 gig (1048576 bytes), DATALO is 500 mb (524288 bytes), and INDEXES is 256 mb (262144 bytes).

a) To check settings for NEXT_EXTENT, run nextext.sql.

b) To check existing extents, run existext.sql



2. All tables should have unique primary keys.

a) To check missing PK, run no_pk.sql.

b) To check disabled PK, run disPK.sql.

c) All primary key indexes should be unique. Run nonuPK.sql to check.



3. All indexes should use INDEXES tablespace. Run mkrebuild_idx.sql.


4. Schemas should look identical between environments, especially test and production.
a) To check data type consistency, run datatype.sql.

b) To check other object consistency, run obj_coord.sql.

c) Better yet, use a tool like Quest Software's Schema Manager.

more..