high INSERT statement rate on RAC database
Hi,
we have notice that after migrate from 12.2 to 19.14 (RAC DB/4 nodes), some INSERT statements, which have a high rate of execution, is suffering high wait events like "gc current request" ," gc buffer busy release" , "gc cr request" and "gc buffer busy release".
I have read some notes, like 2337631.1, and so far dba team have increased indexes initrans value from tables involved on those DML. We are observing application and next steps are:
* increase table´s initrans as well ;
* apply dbms ru patch 19.16 ;
* watch application for a while.
I was thinking : if not else works, I am going to redirect my application to work on one instance only ?