Hi, We are using version 11.2.0.4 of Oracle. We have two production databases having equal configuration parameters and are in sync using/through streams replication. Due to some maintenance work on one of the databases , we have moved the traffic to other side and all was running fine for few days but then suddenly we are experiencing high CPU and Concurrency(mainly "libray cache:mutex x" and "latch: cache buffer chains") waits experienced by multiple(~10) sql queries. The underlying object(table/indexes) showing against event "libray cache:mutex x" and "latch: cache buffer chains" are different for each sql query in dba_hist_active_sess_history.
Tried checking the AWR/ASH data related to the queries , not seeing any differences. Not seeing any difference in execution plan_hash_value. No difference in data volume fetched by the queries. Number of execution is also similar. And even seeing no major difference in the "DISK_READS_delta", "BUFFER_GETS_delta" in dba_hist_sqlstat per execution for those queries. Major increase is observed in two parameters i.e. "CPU_TIME_delta" and "CCWAIT_TOTAL". So want experts suggestion , how to proceed to get the root cause/fix of the issue? Is there any chance this isue being related to underlying storage/hardware? What exact other places should i look into to get more inside into this issue?