RE: Sun Memory Upgrade problem

Hi Jared,

The database is on raw devices and there was no paging activity on the system.

Do I miss something here?

Thanks

Waleed
-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Tuesday, June 13, 2000 10:57 AM
To: Khedr, Waleed
Cc: Multiple recipients of list ORACLE-L Subject: Re: Sun Memory Upgrade problem

I'm going to assume that you are using Veritas.

If so, ask the SA how much of the 10G of memory is dedicated to filesystem caching.

Jared

On Mon, 12 Jun 2000, Khedr, Waleed wrote:

> 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).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue Jun 13 2000 - 10:03:36 CDT