EVENT ( library cache: mutex X)

Hello,

We obtain a high number of occurrences in Events on v$active_session_history on production database:

 

1xxy71vw3hv9x library cache: mutex X

54py9tr7vtuat library cache: mutex X

8vh4rhh77y7zw cursor: pin S

f6bdy52njy42d latch: cache buffers chains

f6bdy52njy42d cursor: pin S

 

And we need to reduce this events and study the impact for migrate to RAC the single instance database.

the query used to find mutex:

 

select * from (

select case when (kglhdadr = kglhdpar) then 'Parent' else 'Child '||kglobt09 end cursor,

kglhdadr ADDRESS, substr(kglnaobj,1,20) NAME, kglnahsh HASH_VALUE, kglobtyd TYPE,