Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: count PL/SQL function calls

Re: count PL/SQL function calls

From: Björn Wächter <Bjoern.Waechter_at_p3-solutions.de>
Date: Wed, 10 Aug 2005 15:29:01 +0200
Message-ID: <3ludqiFh458eU1@news.dfncis.de>


Perhaps this helps:

SELECT Owner, Name, Type, Sharable_mem, Loads, Kept, Executions, Locks, Pins FROM v$db_object_cache WHERE type in ('PROCEDURE','PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'TRIGGER', 'SEQUENCE') Received on Wed Aug 10 2005 - 08:29:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US