RE: Sun Memory Upgrade problem

Hi Waleed,

        have you been modified the SGA size?. If so, maybe you got a SGA too big for your processor. If you have a large memory and slow processors, take into account that oracle will waste a lot of time searching a block that is not in the buffer, or a cursor that is not in the pool area.

Take a look at the processor activity (mpstat 5), maybe your bottleneck is there.

HTH Carlo.
> ----------
> De: Khedr, Waleed[SMTP:Waleed.Khedr_at_FMR.COM]
> Responder a: ORACLE-L_at_fatcity.com
> Enviado el: Lunes 12 de Junio de 2000 14:04
> Para: Multiple recipients of list ORACLE-L
> Asunto: Sun Memory Upgrade problem
>
> Hi,
>
> After we upgraded memory on Sun 4500 to 10Gb Oracle performance became
> very
> bad.
> It is almost 50% slower.
> Any ideas?
>
> Also when the sessions parameter becomes high like 4000, setting autotrace
> on in sqlplus becomes very very slow.
> For example select * from dual takes like two minutes.
>
> Thanks,
>
> Waleed
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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).
Received on Mon Jun 12 2000 - 14:35:13 CDT