Re: Excessive "latch: row cache objects" waits with simple INSERT statement
From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Tue, 6 Oct 2020 13:22:04 +0200
Message-ID: <baa1d677-cf23-0f53-d3e9-8d850d8b6c0c_at_mgm-tp.com>
Date: Tue, 6 Oct 2020 13:22:04 +0200
Message-ID: <baa1d677-cf23-0f53-d3e9-8d850d8b6c0c_at_mgm-tp.com>
Yes, looks like it. Apparently Hibernate lies when it claims it's doing batched insert.
No VPD, no triggers.
But I just learned that those INSERTs are done using a 2-phase commit (XA Transaction). Could that be the cause these latch waits?
Jonathan Lewis schrieb am 05.10.2020 um 19:58:
> The fact that the EXEC lines show: " r=1" suggests that you are
> doing single row inserts. For array inserts I'd expect to see
> 'r={size of array}'.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 06 2020 - 13:22:04 CEST