Re: Performance issue with new 9i database

From: anacedent <anacedent_at_hotmail.com>
Date: Sat, 26 Jun 2004 15:29:59 -0700
Message-ID: <INmDc.115$nc.112@fed1read03>

Rick Denoire wrote:

> shankarvs_at_gmail.com (Shankar) wrote:
>
>

>>Hello,
>>I am seeing huge performance problems on the queries executed against
>>9i database. I am not too familiar with 9i, But I would like to ask
>>the DBA to check whether all the parameters are set right to gain
>>optimum performance.

>
>
> After switching from 8.1.7 to 9.2.0.4 on a Solaris box our database
> got much slower. I still had the chance to compare the execution plans
> because we were still able to run the old (renamed) DB version 8.1.7,
> and, of course, they were different. But why?
Why?
Something changed!
What changed?

Exactly how did you "switch" from V8.1.7 to V9.2?

Do you have current stats on V9.2?
Are both V8.1.7 & V9.2 using RBO? Received on Sat Jun 26 2004 - 17:29:59 CDT