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.