Re: Excessive "latch: row cache objects" waits with simple INSERT statement
Date: Fri, 2 Oct 2020 12:31:40 +0100
Message-ID: <CAGtsp8k6QfvHAtQazDmForeqLucCcgkACkXmQKE_T-9uZmyJxQ_at_mail.gmail.com>
Does that mean the insert statement you presented us with initially is nothing like the actual insert statement that's causing the problem ? Lots of schemas using their own declarations of "the same" global temporary table is likely to show completely different characteristics from lost of sessions using the same GTT declaration from a single schema. Does the subsequent select statement also use the schema name to qualify the GTT name ?
*> Recent versions of Oracle allow you to associate an OBJECT with a
temporary > tablespace 12.1 does not seem to be "recent" enough - at least
ALTER TABLE MOVE to define a different tablespace is rejected with:
ORA-14451: unsupported feature with temporary table *
You can't MOVE something that doesn't exist. the CREATE statement will have
to modified to specify a tablespace and then the table will need to be
dropped and recreated. See the second bullett point in the following. This
has been possible since 11g
https://jonathanlewis.wordpress.com/2014/03/14/12c-temporary/
How many different schemas have created their private version of this GTT ?
Regards
Jonathan Lewis
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 02 2020 - 13:31:40 CEST