RE: Know anyone?

Not yet. With help we have tuned some queries and that has helped additionally, but there are still spikes that slows everything. We noticed yesterday that context switching goes really high (300,000 +) when the spike hits. We're trying to determine why that is.

-----Original Message-----
From: Parker, Matthew [mailto:matthewp_at_amazon.com] Sent: Thursday, July 28, 2005 4:54 AM
To: Magnus.Andersen_at_WalkerFirst.com; dbvision_at_iinet.net.au Cc: Oracle-L (E-mail)
Subject: 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