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

i guess KGLHDLMD is lock Mode ? and KGLHDPMD = mode pinned ?

> ----------
> From: Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Sent: Tuesday, October 30, 2001 3:51 PM
> To: Rahul; Multiple recipients of list ORACLE-L
> Subject: 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-----
> From: Rahul [mailto:rahul_at_ratelindo.co.id]
> Sent: Tuesday, 30 October 2001 17:18
> To: Rahul; Multiple recipients of list ORACLE-L; 'Steve Adams'
> Subject: RE: How can I tell if a procedure/package is running?
>
>
> 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: 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).