Oracle Global Temporary Tables creating the inactive locks
We have used one procedure to insert the data in the session based GTT,inorder to read the data which is inserted in only that particular session.
The program is working fine, but every session is creating inactive locks with lock type as 'TO' and mode=3
Please help us to rectify this inactive locks.
Following definition of the GTT which we have used.
CREATE GLOBAL TEMPORARY TABLE XX_GTT (
COLUMN1 VARCHAR2(20)
)
ON COMMIT PRESERVE ROWS;