Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

performance vs auditing

user8983130Feb 12 2014 — edited Feb 24 2014

Hi,

I have created 2 user to perform insert,update,delete on application schema. And to trace the activity i have enable auditing by: audit insert any table,update any table,delete any table by test;

I have some query regarding this:

1. The user needs to perform dml 2-3 times a week, enabling auditing could be a any performance issue??

2.Is there any command to enable auditing instead of audit insert any table , it would be insert any table on schema ??

3.How could we disable auditing for particular user??


4.Enabling auditing ,which are of resource would be affected, i meant which portion need to keep chking??

Regards,

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2014
Added on Feb 12 2014
10 comments
3,873 views