RE: RAT fully backported to 10g and 9iR2...

From: <Joel.Patterson_at_crowley.com>
Date: Fri, 9 Oct 2009 13:20:09 -0400
Message-ID: <0684DA55864E404F8AD2E2EBDFD557DA037012C2_at_JAXMSG01.crowley.com>



Thank you for the info. I believe I may have mixed up SPA with SPM, but in any event I wrote down SPM, and was referring to that note when I made the comment.

I'll check out your links.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: Job Miller [mailto:jobmiller_at_yahoo.com] Sent: Friday, October 09, 2009 9:07 AM
To: robertgfreeman_at_yahoo.com; oracle-l_at_freelists.org; Patterson, Joel Subject: RE: RAT fully backported to 10g and 9iR2...

Joel,

SPM is part of EE. It is not extra cost.

The licensing guide which is included in the documentation here explains that:

http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/editions.htm#CJACGHEB

If you want to better understand SPM, try the chapter called "Using SQL Plan Management" in the Perfomance Tuning Guide here:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28274/optplanmgmt.htm

RAT (which includes SPA) is an option. The above licensing link also explains that.

If you want cost, check out the Oracle Store, it explains the list cost for each option, edition, product, etc:

http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=103670&sitex=10021:22372:US

SPA and SPM have complimentary roles. SPA can be used to create a plan baseline for a query that was shown to regress in SPA testing.

SPM and STA/Profiles are also integrated as described in the above "Using SQL Plan Management" document.

Job
--- On Thu, 10/8/09, Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com> wrote:

> From: Joel.Patterson_at_crowley.com <Joel.Patterson_at_crowley.com>
> Subject: RE: RAT fully backported to 10g and 9iR2...
> To: robertgfreeman_at_yahoo.com, oracle-l_at_freelists.org
> Date: Thursday, October 8, 2009, 12:35 PM
>
> Yes, the cost.  Havn't looked so if anyone has a ball
> park let me know.
> (any example is good enough).
>
> RAT.  It seems to me that perhaps some are mixing SPM
> (SQL Plan
> Management) in with RAT with regards to upgrading and
> keeping the best
> execution plans.
>
> SPM is also another extra cost option, just in case one was
> wondering.
> P.S.  if you have a cost example for this one to, I'd
> be interested.
>
> So, is it not two extra cost options to do this the 11g
> way?
>
> Joel Patterson
> Database Administrator
> 904 727-2546
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Robert Freeman
> Sent: Wednesday, October 07, 2009 1:05 PM
> To: oracle-l_at_freelists.org
> Subject: RAT fully backported to 10g and 9iR2...
>
> Anyone use RAT much yet, or is licensing an issue?
>
> http://searchoracle.techtarget.com/news/article/0,289142,sid41_gci132096
> 6,00.html?asrc=SS_OracleD2DBUpgrad
>
> Robert G. Freeman
> Oracle ACE
> Ask me about on-site Oracle Training! RMAN, DBA, Tuning,
> you name it!
> Author:
> Oracle Database 11g RMAN Backup and Recovery (Oracle Press)
> - ON IT'S
> WAY SOON!
> OCP: Oracle Database 11g Administrator Certified
> Professional Study
> Guide (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Other various titles
> Blog: http://robertgfreeman.blogspot.com
>
>
>
> ----- Original Message ----
> From: Rich Jesse <rjoralist_at_society.servebeer.com>
> To: oracle-l_at_freelists.org
> Sent: Wed, October 7, 2009 10:32:10 AM
> Subject: Re: major blunders
>
> > Compiling a list of major blunders to avoid:
> >
> > Don't use the number 8 for scripting or ORACLE_SID due
> to the wild
> card
> > character * above it.
> > Don't use rm *.*
> > ....
> >
> > Anyone else have some to contribute?
>
> Before instance shutdown:
>     SELECT * FROM V$INSTANCE to verify what
> you're shutting down.
>     SELECT * FROM V$SESSION (or some variant) to
> see what's connected.
>
> Don't practice recovery on the same server as the
> recoverable DB.
>
> Use colors in Unix command line prompts -- red for Prod,
> green for Dev,
> etc.
>
> Use instance name in SQL prompt.
>
> Make your terminal scrollback very large -- mine's at least
> 5000 lines.
>
> Before logging off of ANY remote Windows session, repeat
> several times
> OUT
> LOUD your intentions to logoff and NOT shutdown the server
> before you
> actually click the buttons (esp important on Win2K
> servers!).
>
> Clean up your room.  Stand up straight.  Pick up
> your feet.  Take it
> like a
> man.  Be nice to your sister.  Don't mix beer and
> wine, ever.  Oh yeah:
> Don't drive on the railroad tracks.
>
> My $.02,
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
      

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 09 2009 - 12:20:09 CDT

Original text of this message