Re: Excessive "latch: row cache objects" waits with simple INSERT statement
From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Fri, 2 Oct 2020 09:22:40 +0200
Message-ID: <09c7efd6-dfd5-d986-f03c-fd235fbbb5b3_at_bluewin.ch>
Date: Fri, 2 Oct 2020 09:22:40 +0200
Message-ID: <09c7efd6-dfd5-d986-f03c-fd235fbbb5b3_at_bluewin.ch>
Might be absurd, but what if the tablespace in Question or the underlying file accidently got a small extend size?
regards
Lothar
Am 02.10.2020 um 09:11 schrieb Thomas Kellerer:
> Mark W. Farnham schrieb am 01.10.2020 um 21:51:
>> I don’t know whether it is worth the trouble or space, but in some
>> cases that can be mitigated by creating a temporary tablespace for
>> that singular user.
> We will try that. It's not a big deal to create a separate temp tablespace for the users in question.
>
> Regards
> Thomas Kellerer
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 02 2020 - 09:22:40 CEST