Oracle internals, debugging and undocumented features
Everyone knows how to enable database auditing .That’s for sure.But to make auditors happy is another story.One of the requirements is that all these data from the source should be stored somewhere else.. but not on source ..
If you have plenty of money you can get Oracle audit wault.But if you don’t than you make your own audit wault using Oracle Streams.I called it Poor man audit wault.There is metalink note DML and DDL Auditing Using Streams which explains this into detail.
I run into this presentation many months ago and again today.. What trigger my attention is that if I correctly remember audit vault use same technology beneath to offload data and load into vault data warehouse database…
Principle is simple.Streams capture process run of different database .Not on the one where redo is generated.This feature is called Downstream capture.Redo logs are transfered to different database and mined by capture process.All auditing work can be offloaded to downstrem database.
Metalink Note: 316893.1
and also :