RE: How can I tell if a procedure/package is running?

I think 1 is NULL mode and 3 is EXCLUSIVE mode. No idea abt 0.

Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-----Original Message-----
Sent: Monday, October 29, 2001 10:00 PM
To: Multiple recipients of list ORACLE-L

out of curiosity...
what does the values 0 and 1 implies ? ( in X$KGLOB.KGLHDPMD)

> ----------
> From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, October 30, 2001 10:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How can I tell if a procedure/package is running?
>
> Hi Doug,
>
> 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.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/ - For DBAs
> @ http://www.secularislam.org/call.htm - For Muslims
> @ http://www.christianity.net.au/ - For all
>
> -----Original Message-----
>
> How can I tell if a stored procedure or package is in the middle of
> execution?
>
>
> --------------------------------------------------------------------------
> -------
> You can view this message online at
> http://www.ixora.com.au/q+a/0110/30141015.htm
> To unsubscribe from Ixora Answers send a blank email to
> quit-answers_at_ixora.com.au
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> 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: Rahul
  INET: rahul_at_ratelindo.co.id

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).


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

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).