Re: Idle events list

I believe statspack has a config table, list alll the idle event. you can check it.

 On 8/20/05, Allen*, Brandon* <Brandon.Allen_at_oneneck.com> wrote:
>
> Not sure if this is complete or not, but it's a start - this is from a
> script that I copied from an article by Roger Schrag & Terry Sutton (
> http://www.dbspecialists.com/presentations/wait_events2.html):
> 'client message', 'dispatcher timer', 'gcs for action',
> 'gcs remote message', 'ges remote message', 'i/o slave wait',
> 'jobq slave wait', 'lock manager wait for remote message',
> 'null event', 'Null event', 'parallel query dequeue', 'pipe get',
> 'PL/SQL lock timer', 'pmon timer', 'PX Deq Credit: need buffer',
> 'PX Deq Credit: send blkd', 'PX Deq: Execute Reply',
> 'PX Deq: Execution Msg', 'PX Deq: Signal ACK',
> 'PX Deq: Table Q Normal', 'PX Deque Wait', 'PX Idle Wait',
> 'queue messages', 'rdbms ipc message', 'slave wait',
> 'smon timer', 'SQL*Net message to client',
> 'SQL*Net message from client', 'SQL*Net more data from client',
> 'virtual circuit status', 'wakeup time manager'
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of *Hameed, Amir
> *Sent:* Friday, August 19, 2005 12:25 PM
> *To:* oracle-l_at_freelists.org; racdba_at_freelists.org
> *Subject:* Idle events list
>
> --

Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>

--
http://www.freelists.org/webpage/oracle-l