Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Idle events list
Hi,
Ok since I am idle some of the idle events are mentioned in the Performance Manual
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10752/instance_tune.htm#16571
Section:
Idle Wait Events
Also from the Reference Manual
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/waitevents004.htm#i970960
under each event it is mentioned whether the event is idle or not.
E.g pmon timer
This is the main wait event for PMON. When PMON is idle, it is waiting on this event.
Regards,
Fairlie
"Hameed, Amir" <Amir.Hameed_at_xerox.com> wrote:Thanks, but, the reference manual does not indicate whether an event is idle or not.
Amir
-----Original Message-----
From: racdba-bounce_at_freelists.org [mailto:racdba-bounce_at_freelists.org]
On Behalf Of Anand Rao
Sent: Friday, August 19, 2005 8:47 PM
To: racdba_at_freelists.org; oracle-l_at_freelists.org
Subject: Re: Idle events list
Hi,
You can see them all in the Oracle 9i Reference Manual. it includes every wait event that Oracle processes can ever wait for.
Appendix A 'Oracle Wait Events'
if you can't see the wait event here, then it doesn't exist :-)
well, then there are some wait events like
'KJCTS: waiting for tickets' which was introduced in 9.0.1 but never made it into any documentation or external notes...
But, the reference manual is more than enough even for the most advanced
DBA.
cheers
anand
On 20/08/05, Sudhi wrote:
>
>
>
> I thought the online doc did have it. Don't have the url but should be
there
> in perf & tuning manual.
>
>
>
> -Sudhi.
>
>
>
> ________________________________
>
>
> From: racdba-bounce_at_freelists.org [mailto:racdba-bounce_at_freelists.org]
On
> Behalf Of Hameed, Amir
> Sent: Saturday, August 20, 2005 12:55 AM
> To: oracle-l_at_freelists.org; racdba_at_freelists.org
> Subject: Idle events list
>
>
>
> Does anyone have a complete list of all idle events in Oracle 9i2,
including
> idle RAC events?
>
> Thanks
-- http://www.freelists.org/webpage/oracle-l Fairlie Rego Senior Oracle Consultant Optus Telecommunications www.optus.com.au Mobile: +61 4 02 792 405 When I read about the evils of drinking, I gave up reading. --------------------------------- Start your day with Yahoo! - make it your home page -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 19 2005 - 20:32:25 CDT