Re: Stored Procedures/Functions

From: Ramon E. Estevez <com.banilejas_at_codetel.net.do>
Date: Fri, 26 Jul 2002 12:05:21 -0800
Message-ID: <F001.004A3C73.20020726120521@fatcity.com>

Mathew,

Run this query, it worked for me.

HTH Ramon,

SELECT
   (decode(o.kglobtyp,0,'CURSOR',
7,'PROCEDURE',8,'FUNCTION',9,'PACKAGE',

                     11,'PACKAGE BODY',12,'TRIGGER', 13,'TYPE',   14,'TYPE
BODY',
         'OTRO')) "TIPO",

  substr(o.kglnaown,1,25) "ESQUEMA",
  substr(o.kglnaobj,1,30) "NOMBRE",
  s.indx "SID",
  s.ksuseser "SERIAL"
FROM

  sys.X_$KGLOB  o,
  sys.X_$KGLPN  p,
  sys.X_$KSUSE  s

WHERE

  o.inst_id = USERENV('Instance') AND
  p.inst_id = USERENV('Instance') AND
  s.inst_id = USERENV('Instance') AND
  o.kglhdpmd = 2 AND
  o.kglobtyp IN (0, 7, 8, 9, 12, 13, 14) AND
  p.kglpnhdl = o.kglhdadr AND
  s.addr = p.kglpnses

ORDER BY 1, 2, 3
/

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 26, 2002 12:19 PM

> Dear Gurus
>
> How would one monitor when and who may be executing a stored
> procedure/package etc at any one point in time. Similar to table locks
> although thats more straightforward to monitor.
>
> Pls advise
>
> Thanks in Advance
>
> IMPORTANT: This e-mail (including all attachments) is confidential and
> may be privileged. It may be read, copied and used only by the intended
> recipients, and must not be re-transmitted in any form without our
consent.
> If you have received it in error, please contact us immediately by return
> e-mail. Please then delete it and do not disclose its contents to any
> other person.
>
> Security and reliability of email is not guaranteed. Communications should
> be verified from a mailed or faxed copy. All emails to anyone @vitol.com
> are communications to the firm and are not private or confidential to any
> named individual.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Easaw T Mathew
> INET: etm_at_VITOL.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

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

Received on Fri Jul 26 2002 - 15:05:21 CDT