Get started Bring yourself up to speed with our introductory content.

The Oracle Guru Answer #16

The Oracle Guru Answer #16

Were you correct? This week's answer is:
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.

Click for more information on new Oracle10g features.

For More Information

Tip: Don Burleson's favorite Oracle10g new features

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!

Dig Deeper on Oracle DBA jobs, training and certification

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.