Re: Idle events list
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx
- Date: Sat, 20 Aug 2005 07:52:48 +0800
I believe statspack has a config table, list alll the idle event.
you can check it.
On 8/20/05, Allen*, Brandon* <Brandon.Allen@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *Hameed, Amir
> *Sent:* Friday, August 19, 2005 12:25 PM
> *To:* oracle-l@xxxxxxxxxxxxx; racdba@xxxxxxxxxxxxx
> *Subject:* Idle events list
>
> --
Regards
Zhu Chao
www.cnoug.org <http://www.cnoug.org>
Other related posts:
