Re: Difference in writer response time

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_at_gmail.com> 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.
>

--
http://www.freelists.org/webpage/oracle-l