Re: Auditing
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Bill Ferguson <wbfergus@xxxxxxxxx>
- Date: Wed, 4 Mar 2009 12:08:14 -0600
Turn on auditing, and tell them to hire a cheap summer intern to write the
reports. You're too busy.
On Wed, Mar 4, 2009 at 12:06 PM, Bill Ferguson <wbfergus@xxxxxxxxx> wrote:
> I've turned that on for a couple of tables so we can test the
> resulting data generated, but trying to query against the
> FLASHBACK_TRANSACTION_QUERY view takes hours. I have no idea why, but
> it's horrendously slow, as if there's no index. Being a system table
> and view, I don't want to mess with it.
>
> And looking at the data generated from it, it doesn't look like it
> would meet their ideas of the useless summary reports they want to
> generate either, like Gold was changed from Primary to Tertiary 16
> times, Silver was changed from Secondary to Primary 32 times, etc.
>
> --
> -- Bill Ferguson
>
>
>
> On Wed, Mar 4, 2009 at 10:24 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
> wrote:
> > Had you considered just turning on the audit_trail to db_extended or some
> > such, along with a trigger or two to apply any additional information you
> > need? I dont think the extended audit trail would actually be lacking
> much
> > information, as I recall it even contains the undo sql.
> >
>
>
> --
> -- Bill Ferguson
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
