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

Hi Rahul,

Ah, I see. You're looking at KGLHDLMD instead of KGLHDPMD.

@   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-----
Sent: Tuesday, 30 October 2001 17:18
To: Rahul; Multiple recipients of list ORACLE-L; 'Steve Adams'

ADDR INDX INST_ID KGLHDADR KGLHDPAR KGLNAOWN KGLNAOBJ

• --------- --------- -------- -------- ----------

  ---

  ---

2025F078 102 1 315F16D4 315F16D4 SELECT COUNT(*) FROM LETTER WHERE TELEPHONENUMBER = :b1 AND CUSTOMERID = :b2 AND ENDDATE = :b3  

2025F074 108 1 30A2E4F8 30A2E4F8 NC_SASS GIVE_ASCII_VALUE there are queries and also functions with the X$KGLOB.KGLHDPMD as 1, the result from
select * from X$KGLOB where KGLHDLMD =1 are too long to cut-paste here in full.

> ----------
> From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Sent: Tuesday, October 30, 2001 2:45 PM
> To: Rahul; Multiple recipients of list ORACLE-L
> Subject: RE: How can I tell if a procedure/package is running?
>
> Hi Rahul,
>
> 0 means not pinned; 3 means pinned in exclusive mode.
> I don't know what 1 means. I'm not accustomed to seeing it.
> Do you have any examples?
>
> @ 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-----
> From: Rahul [mailto:rahul_at_ratelindo.co.id]
> Sent: Tuesday, 30 October 2001 16:00
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How can I tell if a procedure/package is running?
>
>
> 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?
>

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