e. Automatic Workload Repository
Oracle10g's Automatic Workload Repository defaults to a collection interval every 30 minutes and collects data that is the foundation for all of the other self-tuning features. AWR is very much like Statspack, especially the level-5 Statspack collection mechanism where top SQL is collected every hour based on your rolling thresholds for high-use SQL. In addition to the SQL, AWR collects detailed run-time statistics on the top SQL (disk reads, executions, consistent gets) and uses this information to adjust the rolling collection threshold. This technique ensures that AWR always collects the most resource-intensive SQL.
For More Information
Article: Beta testers give 10g rave reviews
White paper: Oracle 10g: Infrastructure for grid computing
Do you have an idea for a quiz question topic? Let us know!