Oracle Database Discussions

Hi,

I am a novice to auditing, also I am a Java developer so please bear with me if I ask too obvious a question related to this. I am creating a User Interface that shows an admin user (or a secured user) a list of tables and columns. The user can select columns on these tables to enable auditing. This is a very generic app that can be used by anyone (so potentially there can be thousands of tables).

Once the audit trail is recorded I also have to create a UI that shows this audit trail and this UI includes showing the old and new values. I see that to get an old and new value I can use flashback query or create a trigger and save this data in shadow tables. Neither of which is an acceptable solution for the generic UI I am creating.

My questions are:
1. Is there some other way to store this data?
2. Can I use fine grain auditing's "add policy" -> "handler_module" to a write a procedure that can capture this data? Is there an example for this?
3. Instead if I have to use flashback query what is the performance impact of enabling flashback and also what is the database memory impact?

Your inputs in this are greatly appreciated.

Thanks,
Pallavi