A lot of attention has been focused on technical standards for Cloud computing, especially over the last month (e.g. DMTF incubator announcement). That’s fine, but before we go crazy with detailed technical standards let’s realize that for Cloud computing (of the public variety at least) to take off we’ll need just as much standardization of [...]
Now that we have learned how to create Statspack-Style performance reports from Automatic Workload Repository snapshots, let’s run an ADDM task and an intelligent advisor or two and let 10G Grid Control do the diagnostic grunt work for us. As I ranted in my previous blog, ADDM and the intelligent advisors are the future of [...]
This blog should be a quick and easy read. I will admit that this is a weird combination of topics. We are going to learn how to generate traditional, Statspack-style performance reports from the Automatic Workload Repository. This blog also contains my thoughts on the future of database tuning. And the future does NOT include [...]
Now that we have completed our discussion on the 10G EM Advisors, let’s take an in-depth look at the performance statistics capturing and reporting capabilities provided by 10G EM. Oracle 10G captures performance statistics on a periodic basis and stores the data in the Automatic Workload Repository. The individual statistic capture executions are called AWR [...]