Re: Auditing

From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Wed, 4 Mar 2009 11:06:04 -0700
Message-ID: <4025610e0903041006h2b665e30n44ecda2f71d23cff_at_mail.gmail.com>

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
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 04 2009 - 12:06:04 CST