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!

audit log AUD$ table and Query...

The_RockMar 11 2010 — edited Mar 12 2010
We have enabled auditing for DB user ERP, 'DB, EXTENDED', we restored our ERP schema day before yesterday, and today When I checked the log file, its size is 4.3GB, before that the file size was 60 MB.

When I queried to check the total rows with sysdate-1, there are 66,60,756 rows, before the ERP schema restoration there were around 30,000 rows.

I have not changed the query.
The AUD$ table size is increasing rapidly, its size has become over 10GB in two days.

PLease help me... what should I do?

Regards,
Rakesh Soni,
http://rakeshocp.blogspot.com/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2010
Added on Mar 11 2010
16 comments
6,652 views