My Oracle Support Banner

DML and truncate operations are blocked by another session doing tablespace resize (Doc ID 3061881.1)

Last updated on DECEMBER 06, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

DML and truncate operations may be blocked by the 'enq: TT - contention' wait event while a bigfile tablespace is being resized to a huge size.
For example, session 1 runs the following command to extend a bigfile tablespace to a very large size:

While this resize operation is running, it holds several "TT" enqueues in X mode. This can block other sessions from executing any extent allocation or deallocation operations within the same bigfile tablespace. As a result, DML statements and TRUNCATE operations may be blocked. If the file extension takes hours to complete, this could lead to long wait times for those sessions.

This document explains the scenario and outlines potential workarounds to alleviate the contention.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.