Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: count PL/SQL function calls
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