From oracle-l-bounce@freelists.org Wed Mar 3 12:00:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23I0vm03428 for ; Wed, 3 Mar 2004 12:00:57 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23I0to03413 for ; Wed, 3 Mar 2004 12:00:56 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2BBA3394EF6; Wed, 3 Mar 2004 13:01:12 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 12:59:55 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from uranium.btinternet.com (uranium.btinternet.com [194.73.73.89]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3E62B39498E for ; Wed, 3 Mar 2004 12:59:52 -0500 (EST) Received: from [81.132.83.94] (helo=Primary) by uranium.btinternet.com with smtp (Exim 3.22 #25) id 1Ayaid-0006eh-00 for oracle-l@freelists.org; Wed, 03 Mar 2004 18:03:43 +0000 Message-ID: <005201c40149$df5ef840$6702a8c0@Primary> From: "Jonathan Lewis" To: References: <0HU000MA7FXKPA@sys98049.heb.com> Subject: Re: GTT Locks Date: Wed, 3 Mar 2004 18:03:31 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 206 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Notes in-line Jonathan Lewis http://www.jlcomp.demon.co.uk The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html March 2004 Hotsos Symposium - The Burden of Proof Dynamic Sampling - an investigation March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial April 2004 Iceland June 2004 UK - Optimising Oracle Seminar ----- Original Message ----- From: "Ravi Kulkarni" To: Sent: Wednesday, March 03, 2004 5:15 PM Subject: RE: GTT Locks > John, > Jonathan > > The table GTT needs to be a Global Temporary table. > Absolutely true - I don't know how I managed to forget the GT bit when I was doing the test Having corrected the error, I agree with your observations: insert into gtt values (1); Locks: TY ID1 ID2 LMODE -- ---------- ---------- ---------- TX 131091 7538 6 TO 30494 1 3 commit; insert into gtt select rownum from user_objects where rownum = 1; TY ID1 ID2 LMODE -- ---------- ---------- ---------- TX 393219 7548 6 TM 30494 0 3 TO 30494 1 3 commit; begin for i in 1..10000 loop insert into gtt values (i); end loop; end; / TY ID1 ID2 LMODE -- ---------- ---------- ---------- TX 458780 7532 6 TO 30494 1 3 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------