Re: following a user

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Fri, 12 Nov 1999 07:44:34 -0500
Message-ID: <jQssOLtbmM3FfoGxshay0q3Qt1s9@4ax.com>

A copy of this was sent to Kenny <karosenb_at_erols.com> (if that email address didn't require changing) On Thu, 11 Nov 1999 17:03:16 -0500, you wrote:

>> Greetings:
>
>Im trying to monitor my tables. I want to know when an insert/update/delete was
>done, by whom, and what time. To this point I have used Oracle TRacing to get this
>information, but have been experiencing performance hits and huge logfiles. There
>must be a better way to get this info without Tracing all sessions
>
>ANy info would be great, please respond to me as well....karosenb_at_erols.com
>Cheers
>-kenny
>
>

Look at database auditing -- See the server admin guide. It will put a row in a table when someone inserts/updates/deletes (if you tell it to) which this sort of information.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri Nov 12 1999 - 06:44:34 CST