Re: help my senility - is there a way to change how often PMON wakes idle processes?

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Wed, 14 Feb 2007 19:21:16 -0800
Message-ID: <3b0f44a10702141921t4dbf1345xe3d84ad359f270f1@mail.gmail.com>

Mark,

Not sure whethere there are any direct ways of changing that interval. However if you do a 10246 (not 10046 !) trace, you can get the pmon operations in the trace file. However there are certain events to wakeup/sleep pmon, butnot changing the intervals.

-Gopal

On 2/14/07, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> I'm having trouble finding any documentation on this and a no find is just a
> reason to believe I just am searching badly rather than it doesn't exist.
>
> If I recall correctly, PMON wakes up idlers every so often to see if they
> are still there (maybe 3 seconds?). If I just flat out have that wrong,
> someone say so, and if not, does anyone know a way to change the frequency?
>
> Thanks,
>

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 14 2007 - 21:21:16 CST