Re:How to find Procs run?

From: <dgoulet_at_vicr.com>
Date: Fri, 31 Aug 2001 09:51:31 -0700
Message-ID: <F001.0037F9A8.20010831100012@fatcity.com>

Scott,

Try turning on auditing, as in 'audit execute on <procedure> whenever successful'

Dick Goulet

____________________Reply Separator____________________
Author: Scott Canaan <srcdco_at_ritvax.isc.rit.edu>
Date:       8/31/2001 9:04 AM

First, I will say that I will contribute something to keep this list alive. I have benefitted way more from the list than I have given.

With that said, I have a request from a customer to do a weekly report on which stored procedures are run and by whom. I have been looking in v_$sql, v_$sqlarea, v_$session, etc. and am having some limited success. The problem is that Oracle doesn't seem to keep any history of what happened in the past, only what the system looks like now. I also tried to create a table to hold the information and have a trigger on one of these views (I also tried the underlying tables), but Oracle won't let me create a trigger on any of these.

I don't know where else to go, and I hate to tell a customer that I can't do it, but I'm out of ideas. Anyone here have any?

Thank you,

--

Scott Canaan (srcdco_at_rit.edu)
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Scott Canaan
INET: srcdco_at_ritvax.isc.rit.edu

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:
INET: dgoulet_at_vicr.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