latch: cache buffers chains
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Fri, 1 Oct 2021 12:05:46 +0300
Message-ID: <CA+riqSUjRnBv7Mo7P8WHR=cQyoVD1Frf8upgXZCQbjKdizpdfA_at_mail.gmail.com>
Hello everyone.
Date: Fri, 1 Oct 2021 12:05:46 +0300
Message-ID: <CA+riqSUjRnBv7Mo7P8WHR=cQyoVD1Frf8upgXZCQbjKdizpdfA_at_mail.gmail.com>
Hello everyone.
Version 12.1
Looks like for a sql statement executed in standby database, with parallel, that selects data from a GTT (with on commit delete rows) the PX slaves spends a significant amount of time into latch: cache buffers chains and read by other session . Same query executed in primary database has no issues. THis issue is observed just for GTTs.
Anyone have any ideas on how to mitigate this issue?
THank you.
--http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2021 - 11:05:46 CEST