11g kokc latching problem??
Date: Wed, 15 Oct 2008 17:40:38 +0530
Message-ID: <c515faee0810150510y395bbf6frf00305c5d05d5229@mail.gmail.com>
Hi Gurus,
We had started some online performance testing of our application on 11g (
11.1.0.7) . There seems to be a severe latching problem on kokc descriptor
latch. I understand that this is a new latch in 11g and not able to find
anything beyond that. The same test went fine on 10g R2. Metalink has no
hits on this have any one of you faced a similar problem in 11g and any
possible hints/undocumented parameters that can help?
have copied relevant sections from AWR
Top 5 Timed Foreground Events
*Event*
*Waits*
*Time(s)*
*Avg wait (ms)*
*% DB time*
*Wait Class*
latch free
566,894
184,570
326
93.68
Other
DB CPU 10,676
5.42
log file sync
76,340
1,184
16
0.60
Commit
library cache: mutex X
2,283,183
360
0
0.18
Concurrency
SQL*Net more data from client
105,660
117
1
0.06
Network
Latch Statistics
Latch Name
Get Requests
Pct Get Miss
Avg Slps /Miss
Wait Time (s)
NoWait Requests
Pct NoWait Miss
kokc descriptor allocation latch
3,968,130
18.59
0.88
174283
0
Latch Miss Source
*Latch Name*
*Where*
*NoWait Misses*
*Sleeps*
*Waiter Sleeps*
kokc descriptor allocation latch
kokcdlt: regular free
0
327,851
265,626
kokc descriptor allocation latch
kokcdlt: allocation
0
321,646
383,871
- * Best Regards,
Sriram Kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 15 2008 - 07:10:38 CDT