Configuring 10G OEM Grid Control Maintenance Windows
Now that we have a general understanding of the important role that statistics play in query optimization, let’s forge ahead with our discussion on statistics administration best practices. In this blog, we’ll learn how to configure 10G Grid Control R2’s maintenance windows to tailor them to meet our application’s business processing requirements. In the next blog, we’ll examine the optimizer statistics gathering default options page and discuss what some of the recommended settings should be.
In the last blog of this series, we’ll complete our discussion on 10G Grid Control R2 optimizer statistics administration by learning how to schedule optimizer statistics gathering jobs manually.