5 May
Deriving Optimal Configuration Values Using 11g Database Replay
Presented by: Jeremiah Wilton, Blue Gecko
OK, so, no, I’m not going to steal Jeremiah’s thunder here. What I am going to do is post his presentation, and give you a teaser: All bias aside, Real Application Testing is a truly revolutionary 11g feature that every DBA should get to know. As Jeremiah demonstrates, its uses go far beyond planning an 11g upgrade. In his presentation, he outlines a strategy (showing his work) to iterate over proposed parameter or system changes and measure the actual result before production implementation. He compares his results to the AWR database advisors, and the results are very interesting.
Here’s the presentation – more on this later:
Deriving Optimal Configuration Values Using 11g Database Replay
If you’re at Collaborate tomorrow (Wednesday 5/6) and you don’t catch Jeremiah’s next presentation, you’ve wasted your money.
Very good article!
I want to do play with the Real Application Testing on our OLTP database. Can you tell me what is the performance impact on the system during the workload collection? Our system is mission critical so adding additional load during peak hours can cause unnecessary problems.
Thanks!