Raj,
I don't remember what version you said you were using but you might want to
investigate
stored outlines. If you have a full-size test environment, you could save
away the current
RBO-based execution plans, switch to CBO and gradually get rid of your
RBO-based stored outlines by tuning statements one at a time.
Theoretically, that should work. I haven't tried it myself, though.
Theoretically, it's a way to be on cost-based but continue to use some of
the the rule-based execution plans until your comfortable with the new
stuff.
Cherie Machler
Oracle DBA
Gelco Information Network
"Jamadagni,
Rajendra" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
<Rajendra.Jamadagni cc:
@espn.com> Subject: RE: SQL statement with
hints or without hints
Sent by:
[EMAIL PROTECTED]
04/12/02 01:18 PM
Please respond to
ORACLE-L
Thanks Tim,
At-least now I know I shouldn't tell them to start putting hints. This was
my problem to tell them or not to tell them. This still doesn't solve the
problem for me though, as everyone is still reluctant to move to CBO. And
this is exactly where it gets getting complicated.
Raj
______________________________________________________
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
(See attached file: ESPN_Disclaimer.txt)
ESPN_Disclaimer.txt
Description: Binary data
