Re: Oracle's RAT (Real Application Testing)
Date: Tue, 15 Dec 2009 15:37:35 -0800 (PST)
How many of you on 11g are actually leveraging SQL Plan Management?
Anybody turn on baseline capture? It's off by default.
Did anybody pre-seed 10g plans into 11g SPM with SPA?
Or did anybody upgrade, run their workload with OFE 10.2 to establish baselines with 10gr2 stats and than update stats and change OFE to 11g ad see what if anything evolves? This is one of the approaches discussed in the various SPM/11g Optimizer sessions from OOW or at the BI/DW Sig that Maria presented at.
SPA (part of RAT) and/or Tuning Pack will help with capture of SQL statements into STS for execution of those statements in 11g environment. If things regress during the SPA run in the 11g env, you can either build profiles to tune or seed the baseline with the 10g plan to ensure it doesn't regress.
what about auto sql tuning? anybody letting the auto sql tuning task automatically create profiles in 11g? Are you reviewing what its identifying as candidate SQL profiles?
any experiences to share for people upgrading to 11g soon with SPM and auto sql tuning?
While SPM will negate much of the risk of plans changing on you, only RAT will tell you in advance how in aggregate the upgrade will affect your workload at full concurrency.
- On Tue, 12/15/09, jason arneil <jason.arneil_at_gmail.com> wrote:
> From: jason arneil <jason.arneil_at_gmail.com>
> Subject: Re: Oracle's RAT (Real Application Testing)
> To: lyallbarbour_at_sanfranmail.com
> Cc: oracle-l_at_freelists.org
> Date: Tuesday, December 15, 2009, 3:49 PM
> I'm looking at an 11gR2 upgrade soon
> myself. There was no way I could
> justify the expense of RAT for what would realistically be
> a piece of
> software that we would not use all that frequently.
> However, I'm really liking the look of SQL Plan Management.
> prospect of guaranteeing that your pre-upgrade plans will
> remain in
> place (and more importantly won't go South upon upgrading)
> with the
> prospect of swapping in better plans as the optimizer in
> the upgraded
> db finds them seems like a winner to me.
> As far as I can see this gives better bang for your buck
> (pound, euro,
> etc.) than RAT, for an upgrade.
> 2009/12/15 <lyallbarbour_at_sanfranmail.com>:
> > So, we'll be moving to 11gR2 soon enough and at a
> local Oracle seminar a
> > couple weeks ago, they had a white paper for upgrading
> to 11gR2. Typical
> > plans, things like that. Oracle's RAT was talked
> about alot and i've been
> > looking at it on Oracle.com and reading white papers
> about it and Tuning
> > Advisors and such.
> > Does anyone have some real life experience with RAT
> that they can share?
> > I've never really looked at how expensive different
> things are from Oracle,
> > but 12k USD per processor seems expensive enough where
> i'd need lots of good
> > reasons for my boss to suggest RAT for our main OLTP
> database upgrade.
> > Thanks,
> > Lyall