RE: Know anyone?

Hi All,

I've had one full day without any issues. What seems to be the silver bullet was to implement Hugetlb. I found out that you do not have to patch version 9.2.0.6 to use it. A good article on Metalink with step-by-step instructions on implementation is Doc ID: 262004.1. The only thing to keep in mind that if you don't need to use VLM you don't have to use the use_indirect_buffer parameter as suggested in Step 4. It works great without it.

Thanks for the help and support.

Magnus

-----Original Message-----
From: Nuno Souto [mailto:dbvision_at_iinet.net.au] Sent: Thursday, July 28, 2005 7:39 AM
To: Magnus Andersen
Subject: Re: Know anyone?

Magnus Andersen apparently said,on my timestamp of 28/07/2005 9:03 PM:
> 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.

Keep us all posted, please. I've hit similar problems from time to time, also on RH and 9.2.0.6. No pattern here, it just happens. I'll be damned if I know what it is.

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