RE: GTT Locks
- From: Ravi Kulkarni <kulkarni.ravi@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 02 Mar 2004 17:25:51 -0600
The lock get cleared after commit, as expected.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Roger Xu
Sent: Tuesday, March 02, 2004 5:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: GTT Locks
does it make a difference if you do a commit after your inserts?
-----Original Message-----
From: Ravi Kulkarni [mailto:kulkarni.ravi@xxxxxxx]
Sent: Tuesday, March 02, 2004 4:52 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
----------------------------------------------------------------
GTT_T TABLE 204835 204835 3
The user acquires a lock on the GTT for performing DML ONLY when selecting from
a Non-GTT.
1. How is this different from the first insert on GTT? (In either case, I
noticed a 'TO' lock-type in v$lock)
2. Where can I find more info on GTT-peculiarities ?
TIA,
Ravi.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
For technical support please email tech_support@xxxxxxxxxxx or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security
System.
************************************************************************
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information. Any
review, dissemination, copying, printing or other use of this e-mail by persons
or entities other than the addressee is prohibited. If you have received this
e-mail in error, please contact the sender immediately and delete the material.
************************************************************************
This email has been scanned for all viruses by the MessageLabs Email Security
System. Any questions please call 972-721-8257 or email your request to
tech_support@xxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
