Re: dropping global temp tables

From: <J.Velikanovs_at_alise.lv>
Date: Fri, 30 Jul 2004 19:12:16 +0300
Message-ID: <OF7D989C8F.A8DFA320-ONC2256EE1.00586E4E-C2256EE1.0059C1DF@alise.lv>

Hi Jonathan,
.
Beside of querying V$SORT_USAGE for purpose to detect how is using GTT, you can use V$LOCK view by restrict TYPE=’TO’. By my option this method is better then suggested before, because you can select exact session, which use exact table you are interested in. .
SELECT l.sid, o.name FROM V$LOCK l, sys.obj$ o WHERE l.TYPE='TO' and l.id1=o.OBJ#;

Best regards,
Jurijs
9268222

http://otn.oracle.com/ocm/jvelikanovs.html

Jonathan Gennick <jonathan_at_gennick.com>
Sent by: oracle-l-bounce_at_freelists.org
29.07.2004 22:43
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        dropping global temp tables

Sorry if this is the dumb question for the day, but how does one go about dropping the definition for a global temp table? DROP TABLE doesn't do the job for me.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit
http://five.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request_at_gennick.com and include the word "subscribe" in either the subject or body.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Fri Jul 30 2004 - 11:25:27 CDT