There's also one usual suspect, I don't see *filesystemio_options*
parameter set, are you running on ASM, not a filesystem, right?
Thanks,
Tanel.
On Thu, Apr 8, 2021 at 4:06 AM Pap <oracle.developer35@xxxxxxxxx> wrote:
Hello Lister, We have two databases which are the same in all the hardware
configurations along with DB parameters and are in sync/replicated using
golden gate. And those are treated as primary and DR for us and both are
active. But we are seeing differences in behaviour when our application
points to primary VS when it points to DR. We are seeing during specific
times of the day when our system is at its peak, in one of the database i.e
DR the DBWR response times spikes till ~200+ms slowing down the write
queries while in another database the dbwr response time stays ~65ms for a
similar amount of data and transaction volume. So wanted to understand what
can cause such drastic differences? Note- Its version 11.2.0.4 of Oracle.
