| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: How can I tell if a procedure/package is running?
Sinardy,
This only tells you if an object exists not if it is running - or even if it is valid unless status is elected from dba_objects as well.
There was a thread around 30/10/01 with the appropriate title 'How can I tell if a procedure/package is running?' - I am not sure if it is the same thread that we are on now. The following quote came from a reply by Steve Adams
You can look at the mode in which the stored procedure or package is pinned in the library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by one or more sessions. If necessary,
you can join to X$KGLPN to find the sessions holding the pins. See "executing_packages.sql" at http://www.ixora.com.au/scripts/misc.htm#executing_packages for an example.
HTH John
-----Original Message-----
From: Sinard Xing [mailto:sinardyxing_at_bcs-ach.com.sg]
Sent: 22 January 2002 08:40
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: How can I tell if a procedure/package is running?
Hi,
You can do
Select object_name, object_type, status
from dba_objects
where object_type like '%PACK%' or
object_type like '%PROCE%'
order by 2,1;
Sinardy
-----Original Message-----
Roland.Skoldblom_at_ica.se
Sent: 22 January 2002 15:10
To: Multiple recipients of list ORACLE-L
Can anyone give me a good example on how this works? Thanks in advance
Roland
Connor McDonald <hamcdc_at_yahoo.co.uk>@fatcity.com den 2001-10-25 01:45 PST
Sänd svar till ORACLE-L_at_fatcity.com
Sänt av: root_at_fatcity.com
Till: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Kopia:
I would say that the best way is in its coding typically by adding calls to dbms_application_info - which is great way of tying SQL to its owning PL/SQL as well.
You might be lucky to catch it in sql_address in v$session (depending on what its actually doing at the time). Similarly, you could possibly glean some info from V$SQL via USERS_EXECUTING
You could always try modify the proc which would probably hang on library cache pin or similar - hardly a recommended way of course :-)
hth
connor
--- Doug C <dcowles_at_i84.net> wrote: > How can I tell
if a stored procedure or package is
> in the middle of execution?
> (for lack of doing what it does).. I've heard of
> parse locks, is that a way?
>
> Thanks,
> D
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Doug C
> INET: dcowles_at_i84.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
"Some days you're the pigeon, some days you're the statue"
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc_at_yahoo.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Roland.Skoldblom_at_ica.se Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: sinardyxing_at_bcs-ach.com.sg Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =========================================================Received on Tue Jan 22 2002 - 05:58:57 CST
 |
 |