Re: Auditing Insert, update and deletes

Perhaps a less intrusive alternative is the SQL*Trax product from BMC Software, which scans the Oracle redo logs (active and archives) and can (among other things) report all inserts, updates, and deletes. Note that "user" information is not logged by Oracle so cannot be retrieved by SQL*Trax. However,
it reports time, day, transaction id, and SCN and generates UNDO for many SQL
statements. More information can be found at www.bmc.com.

Dan Hoffmann
BMC Software, Inc.

JessicaLer <jessicaler_at_aol.com> wrote in article <19961229184800.NAA14896_at_ladder01.news.aol.com>...
> Plan Analyzer for Oracle has a capture facility that will capture all
> statements that run through the server. The capture can be filtered for
> only certain users or roles. You can set the time of day you want to
> capture. You can identify/rank the queries by which are the most
> inefficient or resource intensive.
>
> You can order a free trial from Platinum technology. E-mail Josh Ballard
> at ballj_at_platinum.com and include your address to which he will send a
 CD.
>
> Jamie Lerner
> lernj_at_platinum.com
>
Received on Wed Jan 15 1997 - 00:00:00 CST