Re: Excessive "latch: row cache objects" waits with simple INSERT statement

From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Fri, 2 Oct 2020 09:11:23 +0200
Message-ID: <a8dc7505-04d7-75e4-6049-816a0d7257d6_at_mgm-tp.com>

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

Received on Fri Oct 02 2020 - 09:11:23 CEST

This message: [ Message body ]
Next message: Lothar Flatz: "Re: Excessive "latch: row cache objects" waits with simple INSERT statement"
Previous message: Tim Gorman: "Data transfer between EBS and Dynamics365"
In reply to: Mark W. Farnham: "RE: Excessive "latch: row cache objects" waits with simple INSERT statement"
In reply to Mark W. Farnham: "RE: Excessive "latch: row cache objects" waits with simple INSERT statement"
Next in thread: Lothar Flatz: "Re: Excessive "latch: row cache objects" waits with simple INSERT statement"
Reply: Lothar Flatz: "Re: Excessive "latch: row cache objects" waits with simple INSERT statement"
Reply: Jonathan Lewis: "Re: Excessive "latch: row cache objects" waits with simple INSERT statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message