More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
Oracle DBA Checklist -Collect volumetric data - Nightly Procedures
This example collects table row counts. This can easily be extended to other objects such as indexes, and other data such as average row sizes.
1. Analyze Schemas and Collect Data.
The idea here is to use the more time consuming and more accurate ANALYZE COMPUTE command and save the results, which show up in the data dictionary, to a more permanent store.
a) If you havent' yet, create the volumetrics table with mk_volfact.sql
b) To gather nightly sizing information, run analyze_comp.sql.
c) To collect the resulting statistics, run pop_vol.sql
d) Examine the data at your leisure, probably weekly or monthly.
(Continued on next question...)
