RE: RAT fully backported to 10g and 9iR2...
- From: Patty.Charlebois@xxxxxxxxxxxxxx
- To: JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx
- Date: Wed, 7 Oct 2009 14:43:12 -0400
I don't know how expensive it is, but you have to remember to factor in the
cost of having performance issues in your production databases after you
upgrade if you don't use a tool like this!
I used a similar tool called Laredo by Hotsos when we moved from 9i to 10g. It
worked basically the same way at RAT, comparing execution plans before and
after a change.
I had several large and important batch jobs and some online transactions whose
performance would have been unacceptable if I had just done a straight upgrade
without seeing how the executions plans were going to change when we moved to
10g.
The cost of the software wasn't even close to the cost to the business if those
applications had performed poorly after the upgrade.
Patty
"SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx> Sent by:
oracle-l-bounce@xxxxxxxxxxxxx
2009/10/07 01:14 PM
Please respond to
JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx
To
"robertgfreeman@xxxxxxxxx" <robertgfreeman@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx"
<oracle-l@xxxxxxxxxxxxx>
cc
Subject
RE: RAT fully backported to 10g and 9iR2...
Of course it's fully backported. *wave of the hand* Oracle wants you to
upgrade.... SQL Server is not the RDBMS you're looking for.....
we've looked into it. we've got a 9i DB that needs upgrading and we're
considering going to 11g, but it's just expensive. the good thing is that you
can 'move the license around' if needed. if one of our BU's purchases it, uses
it, no longer needs it (for a project) it can be moved around to another db and
so on....
Jeremy -----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Robert Freeman
Sent: 07 October, 2009 1:05 PM
To: oracle-l@xxxxxxxxxxxxx
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_gci1320966,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@xxxxxxxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
This e-mail is confidential, intended solely for the use of the
recipient(s) to whom it was addressed. If you have received it
in error, please do not copy or distribute this e-mail. We ask
that you notify us immediately by replying to the sender and
then delete this e-mail. E-mail sent or received over the
internet may not be secure. You should use caution when sending
e-mail messages containing private and confidential information
or consider other secure means to send the information. If you
have any questions regarding the authenticity or security of
the e-mail you have received please do not hesitate to contact
us at 1-800-265-5615.
Ce message de courriel est confidentiel et s?adresse uniquement
à la personne indiquée. Si vous l?avez reçu par erreur,
veuillez ne pas copier ni distribuer ce message de courriel.
Nous vous demandons de nous aviser immédiatement en répondant à
l?expéditeur, puis en supprimant ce message. Les messages
envoyés ou reçus par courriel pourraient ne pas être sécurisés.
Vous devriez être prudent lorsque vous envoyez des messages de
courriel contenant des renseignements confidentiels et privés
ou songer à prendre d?autres moyens sécurisés pour envoyer les
renseignements. Si vous avez des questions concernant
l?authenticité ou la sécurité d?un courriel que vous avez reçu,
n?hésitez pas à communiquer avec nous au 1 800 265-5615.
Other related posts:
