Questions & Answers
|
QA-56
|
"cursor: mutex X"
|
Oracle - Database Tuning
|
Open
|
Major
|
UNRESOLVED
|
ubTools Support
|
ubTools Support
|
27/Jul/13 10:25 AM
|
28/Jul/13 05:36 PM
|
|
|
0
|
|
|
|
The customer has upgraded from Oracle 10.2.0.5 to Oracle 11.2.0.3.7. They encountered _library cache lock_ problem.
Some excerpt from the AWR:
{noformat}
Elapsed: 15.01 (mins)
DB Time: 6,548.72 (mins)
.....
Top 5 Timed Foreground Events
Event Waits Time(s) Avg wait (ms) % DB time Wait Class
library cache lock 425 364,186 856909 92.69 Concurrency
enq: TX - row lock contention 288 11,500 39930 2.93 Application
TCP Socket (KGAS) 136,317 9,552 70 2.43 Network
DB CPU 4,167 1.06
db file sequential read 742,541 2,176 3 0.55 User I/O
{noformat}
|
|