Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> GTT Locks
Trying to understand the locking behavior of GTTs (Global Temporary Tables) :
(GTT_T is a GTT. T is a regular table)
SQL> insert into gtt_t values (1000);
1 row created.
SQL> select object_name, object_type, a.object_id, b.locked_mode from dba_objects a, v$locked_object b where a.object_id=b.object_id; no rows selected
SQL> insert into gtt_t select *from T;
1 row created.
SQL> select object_name, object_type, a.object_id, b.locked_mode from dba_objects a, v$locked_object b where a.object_id=b.object_id;
OBJECT_NAME OBJECT_TYPE OBJECT_ID OBJECT_ID LOCKED_MODE
TIA,
Ravi.