Oracle-L: RE: Who has package open

From: Harvey Neil <Neil.Harvey_at_sx3.com>
Date: Thu, 16 Jan 2003 09:24:24 -0800
Message-ID: <F001.00531A04.20030116092424@fatcity.com>

You could try v$open_cursor by SID, but I also use an X$ table (X$KGLLK) with the following SQL:

select *
from x$kgllk
where KGLLKSNM=&sid

This shows what SQL objects a session has touched. It usually gives me what I need.

-----Original Message-----

[mailto:Charlie_Mengler_at_HomeDepot.com]
Sent: 16 January 2003 15:14
To: Multiple recipients of list ORACLE-L

I realize that a package can't be recompiled while a session has it open.

How do I identify which session has a package open?

--

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

Author:
INET: Charlie_Mengler_at_HomeDepot.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately.

No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message.

Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT.
--

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

Author: Harvey Neil
INET: Neil.Harvey_at_sx3.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message