Re: dropping global temp tables

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@xxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
29.07.2004 22:43
Please respond to oracle-l
 
        To:     oracle-l@xxxxxxxxxxxxx
        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@xxxxxxxxxxx

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@xxxxxxxxxxx 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@xxxxxxxxxxxxx
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
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: