My Oracle Support Banner

Global Temporary Table (GTT) Locks When Used With Entity Object In ADF Application (Doc ID 2434719.1)

Last updated on AUGUST 02, 2023

Applies to:

Oracle JDeveloper - Version 11.1.1.9.0 to 12.2.1.3.0 [Release Oracle11g to 12c]
Information in this document applies to any platform.

Symptoms

An ADF Application is using an Entity Object based over a Global Temporary Table set with the option "ON COMMIT PRESERVE ROWS".

When the application is running, it creates database sessions for this Global Temporary Table and those sessions are Active and working normally.
However, once the user stops the activity and the transaction is closed, the session is set to an invalid state and the table gets locked.

Other sessions trying to access the table will then fail with the error:




Changes

 

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!

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