Re: Simple auditing question
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: oracledba.williams@xxxxxxxxx
- Date: Tue, 7 Dec 2010 16:43:46 +0530
Dennis,
There are various types of audit, database level, schema level and table
level.
Audit should be used carefully, it is some sort of extra load on database.
what do you want to audit who fires which statement(this is for database
security..you can use audit) or who changes what data or when and which
business event changes the data (business cycle monitoring..you should
design your application for this)
thanks!
Subodh
On 4 December 2010 01:14, Dennis Williams <oracledba.williams@xxxxxxxxx>wrote:
> List,
>
> I haven't used Oracle Auditing much, so this is probably a newbie
> question. Need to turn on auditing for a high-volume OLTP database. My
> understanding is that if I turn on AUDIT TABLE, it gets everything. I don't
> need to know all the inserts, updates on these tables. Is there a simpler
> audit setting? I probably am missing a concept.
>
> Thanks,
> Dennis Williams
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
