Re: Auditing

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 4 Mar 2009 12:08:14 -0600
Message-ID: <ad3aa4c90903041008j54e6d888hd69df04de2c144c8_at_mail.gmail.com>

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_at_gmail.com> 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_at_gmail.com>
> 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.'

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 04 2009 - 12:08:14 CST