RE: Know anyone?

Did you ever get past your problem?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Magnus Andersen Sent: Saturday, July 23, 2005 7:46 AM
To: 'dbvision_at_iinet.net.au'
Cc: Oracle-L (E-mail)
Subject: RE: Know anyone?

I am running 9.2.0.6

Magnus

-----Original Message-----
From: Nuno Souto [mailto:dbvision_at_iinet.net.au] Sent: Saturday, July 23, 2005 5:43 AM
Cc: Oracle-L (E-mail)
Subject: Re: Know anyone?

Magnus Andersen apparently said,on my timestamp of 22/07/2005 11:28 PM:
> 1. Iostat looks good. Vmstat indicated memory contention, because RedHat
> cache has it all.
> 2. Sar indicates that all looks good.
> 3. Been all over it and used it together with Oracle docs to setup server.
> 4. Great script and I am going to use it next spike. Thanks.
>
> Also, I have sarcheck installed on the server and the analysis from it is
> that the server can support a substantial increase in workload before
> impending CPU, memory, or disk bottlenecks.
>
> I've tried to tune the vm parameters and it help changing the pagecache
> parameter to '1 2 7' instead of default '1 15 30'. Before I did that I
had
> a huge load average all the time. I've also played with bdflush without
any
> gain in perfomance.

You might already have said this but I don't recall hearing it: exactly WHICH version of Oracle are you running? 9.2.0.what? Down to the last digits, please.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l