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: <sybrandb_at_yahoo.com>
Date: 10 Aug 2005 04:38:11 -0700
Message-ID: <1123673891.129883.200700@z14g2000cwz.googlegroups.com> 





Yes there is, but there is also a package in the database called
dbms_profiler.


>From the above statement one can suspect the function is called for

every row.


You could see this in a standard trace file by looking at the number of
recursive calls.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Aug 10 2005 - 06:38:11 CDT












Original text of this message













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