Hi Friends,
We are running 11.2.0.3.0 and getting a pretty high number of Library cache lock & Library cache: Mutex x
We already used DBMS_SHARED_POOL.MARKHOT to mark the object being select as a HOT and even put this table in memory using KEEP pool.
But Library cache lock & Library cache: Mutex x still too high, causing a performance bottleneck
Any other suggestions for this 2 wait events?
Tks a lot