Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 9 2010
Added on Mar 11 2010
#general-database-discussions
16 comments
6,479 views