enq: TS - contention event
From: <ahmed.fikri_at_t-online.de>
Date: Tue, 3 Aug 2021 11:41:13 +0200 (CEST)
Message-ID: <1627983673681.5310954.61ee1a9a7e9b1ee20abe99392a69f900401c8bc7_at_spica.telekom.de>
Hi all,
Date: Tue, 3 Aug 2021 11:41:13 +0200 (CEST)
Message-ID: <1627983673681.5310954.61ee1a9a7e9b1ee20abe99392a69f900401c8bc7_at_spica.telekom.de>
Hi all,
I have many sessions in wait: event enq: TS - contention event. (select * from gv$session where lockwait is not null)
P2Text = tablespace ID , P2 = 18 --> TEMP01 (temp tablespaces)
in gv$lock:
select request,l.type,username,request from gv$lock l join gv$session s on
l.inst_id = s.inst_id and l.sid = s.sid
I find only my application sessions, where request = 3 and type = TS.
we are using a RAC 12.1.0.2.
In the web I found only this Doc ID 2729042.1.
Is there any way to explain the reason for this TS contention event (remove the cause)?
The Temp tablespace is only 30% in use.
Best regards
Ahmed
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 03 2021 - 11:41:13 CEST