DML blocking
From: Pap <oracle.developer35_at_gmail.com>
Date: Mon, 11 Jul 2022 14:48:01 +0530
Message-ID: <CAEjw_fi3DtRqwDC6TmydsgkLc9aSDLaHz+AOP3XVCd260EKKnQ_at_mail.gmail.com>
Hi We have a customer database on version 19.11.We saw all of sudden most of the session for a INSERT query got blocked and the wait event was showing as "enq: TT - contention [mode=4]" . And the blocking session appeared to be a session executing "ALTER database sql" as below. However , wanted to know if its expected behavior to block application query doing DML on that same tablespace object or we are hitting any bug here?
Date: Mon, 11 Jul 2022 14:48:01 +0530
Message-ID: <CAEjw_fi3DtRqwDC6TmydsgkLc9aSDLaHz+AOP3XVCd260EKKnQ_at_mail.gmail.com>
Hi We have a customer database on version 19.11.We saw all of sudden most of the session for a INSERT query got blocked and the wait event was showing as "enq: TT - contention [mode=4]" . And the blocking session appeared to be a session executing "ALTER database sql" as below. However , wanted to know if its expected behavior to block application query doing DML on that same tablespace object or we are hitting any bug here?
I see a doc "Resize Tablespace Hangs with TT Enqueue Contention (Doc ID 2595875.1)", but it says the ALTER statement itself will hang but doesnt tell anything on, if it will imact any DML on the object residing on that tablespace. It's a bigfile tablespace.
alter database datafile '+DATA_XXXX/XXXXX/DATAFILE/data.XXX.XXXXXX' resize 10000G
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 11 2022 - 11:18:01 CEST