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

From: <>
Date: Thu, 8 Oct 2009 12:35:43 -0400
Message-ID: <>

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-----
[] On Behalf Of Robert Freeman Sent: Wednesday, October 07, 2009 1:05 PM To:
Subject: RAT fully backported to 10g and 9iR2...

Anyone use RAT much yet, or is licensing an issue?,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

  • Original Message ---- From: Rich Jesse <> To: 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
> 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,


Received on Thu Oct 08 2009 - 11:35:43 CDT

Original text of this message