Re: Auditing when a function was executed

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 25 May 2006 07:52:50 -0400
Message-ID: <2e2dnUMoxdEPB-jZnZ2dnUVZ_tmdnZ2d@comcast.com>

<dbaplusplus_at_hotmail.com> wrote in message news:1148556564.001331.275890_at_j55g2000cwa.googlegroups.com...
:I am on HP UNIX 11i using Oracle 9.2.0.5.
: I want to audit when a PL/SQL function is executed. I do not have
: access
: to this Oracle function (It is third party and wrapped, and I cannot
: modify it). Is there anyway e.g., through t DDL triggers to record when
: and who is executing the function. Any ideas are welcome.
:

did a quick search on tahiti and a quick google for 'audit execute'

does this do it for you?

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_48a.htm#2119552

also see if this helps:

http://www.oracle-base.com/articles/8i/Auditing.php

++ mcs Received on Thu May 25 2006 - 06:52:50 CDT