Huge DBF sequential reads by KTSJ while updating securefile LOBS.
Date: Thu, 31 Mar 2022 17:05:32 +0530
Message-ID: <CAOzfMupddDrfqYb-3fa7gg6yeTf5pnWDvBLw9VhmKzqk8Rr44Q_at_mail.gmail.com>
Hi All,
Envt :11.2.0.4 on RHEL 6.5
We are observing slowness in OGG replication on the target side. The replication itself is updating a table which has a secure file LOB. There are a lot of updates performed during this time (Close to 25K in an hour). The FG session waits for "direct path write" as it was created with the NOCACHE attribute. However, the ASH shows that this is internally triggering some space management slaves to do many single block reads. There are no trace files also associated with the W00* processes.
Please find the TKPROF report for the OGG replicat OS process. https://gist.github.com/aryangoti/f49660a4bbb23c58a9f403ac9270eb7a
Snapper for W0003 process.
https://gist.github.com/aryangoti/f2cf46ebcec3920d79f4fb719c01f309
ASH details (5 minutes) when the replication was slow. https://gist.github.com/aryangoti/6674691d7770b6eb667718589633aec5
Please let me know how to troubleshoot this further.,
Thanks,
Goti
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 31 2022 - 13:35:32 CEST