Re: Event dispatcher listen timer
- From: Ricard Martínez <ricard.martinez@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 2 Dec 2010 15:50:22 +0100
Hi
Thanks Taral, but i alredy read the tom article before sending the question,
and still not sure about event, cause the only thing about it in the article
is:
it is a dispatcher startup thing, highly (extremely) unlikely to be
affecting you since the dispatchers would already be up and running when
your application is going.
Its not a very clear definition.
I have search in Reference books of 10g and 11g and this wait event isnt
there. So im trying to find more info about it, without luck, cause in ADDM
report i can see too:
RECOMMENDATION 1: Application Analysis, 100% benefit (7040 seconds)
ACTION: Investigate the cause for high "dispatcher listen timer"
waits.
Refer to Oracle's "Database Reference" for the description of this
wait event.
SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Wait class "Network" was consuming significant database time.
(100% impact [7040 seconds])
But without info about the event, i dont know if this recommendation is
valid or not.
On Wed, Dec 1, 2010 at 7:28 PM, Taral Desai <taral.desai@xxxxxxxxx> wrote:
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5414746274062
>
> 2010/12/1 Ricard Martínez <ricard.martinez@xxxxxxxxx>
>
> Hi
>> I have a 10.2.0.4 RAC on linux 64b with 2 nodes, and doing AWR report of
>> one instance is showing me this:
>>
>> Top 5 Timed Events
>>
>> Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class dispatcher
>> listen timer 1,080 62,845 58,189 10,265.9 Network CPU time 308 50.4
>> control
>> file sequential read 137,959 124 1 20.2 System I/O reliable message 2,598
>> 116 45 19.0 Other db file sequential read 15,259 67 4 10.9 User I/O
>>
>>
>> Im searching info about dispatcher listen timer, but didnt read anything
>> really interesting that can help me understand what is causing this. Im not
>> using MTS.
>> Maybe someone have seen it before an can help me a little to where to
>> look?
>> Thanks
>>
>
>
>
> --
> Thanks & Regards,
> Taral Desai
>
Other related posts:
