Re: Oracle's RAT (Real Application Testing)

  • From: Job Miller <jobmiller@xxxxxxxxx>
  • To: lyallbarbour@xxxxxxxxxxxxxxx, jason.arneil@xxxxxxxxx
  • 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 

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 

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@xxxxxxxxx> wrote:

> From: jason arneil <jason.arneil@xxxxxxxxx>
> Subject: Re: Oracle's RAT (Real Application Testing)
> To: lyallbarbour@xxxxxxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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.
> The
> 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.
> jason.
> --
> 2009/12/15  <lyallbarbour@xxxxxxxxxxxxxxx>:
> > 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 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
> --


Other related posts: