RE: 815 much slower than 734

One thing that I'm running into is the increased memory requirement due to the java machine/interpreter/ whatever. The installation insisted on parameters that create a MUCH larger SGA on my new machine -- large enough that I'm pretty sure there's gonna be a whole lotta swappin' goin' on (goin' on, goin' on)

At 04:55 AM 5/17/00 -0800, you wrote:
>Here's a few places to start:
> Any changed init.ora parameters
> Optimizer mode - if choose do you have statistics
> Queries tuned for rule that the cost optimizer handles poorly (full
>table scans)
> Any invalid indexes
>
>HTH
>Dave
>
>> -----Original Message-----
>> From: Louis BROUILLETTE [SMTP:Louis_Brouillette_at_UQTR.UQuebec.CA]
>> Sent: Tuesday, May 16, 2000 11:54 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: 815 much slower than 734
>>
>> Environment:
>> AIX 4.2.1
>> Oracle 8.1.5
>>
>> I migrated a test database from 7.3.4.5 to 8.1.5.
>> Anything obvious why the 8.1.5 database would be much slower than the
>> 7.3.4
>> database ? Is there an init parameter that I should change to make it
>> faster ?
>>
>> Louis Brouillette
>> Analyste en informatique (DBA)
>> Universite du Quebec a Trois-Rivieres
>> Tel: (819) 376-5011 ext. 2435
>> Email: Louis_Brouillette_at_uqtr.uquebec.ca
>> --
>> Author: Louis BROUILLETTE
>> INET: Louis_Brouillette_at_UQTR.UQuebec.CA
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>--
>Author: Post, David
> INET: Dpost_at_lifelinesys.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>

---
Dennis Taylor
---
The opinions expressed herein are mine. Get your own opinions!