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!

how to turn off logging to $aud

1049533Oct 22 2013 — edited Oct 22 2013

Hello,

Is there a way to turn off logging to the $aud. I was unable to log into the database as I received a ORA-01653 error. Then as sysdba I truncated this table.

SQL> select count(*) from aud$;

COUNT(*)

----------

1755867

SQL> truncate table aud$;

Table truncated.

I'm keen now to just stop writing to this table. I have another database and the $aud there contains only 1974 rows so I'd be sure there is no logging going on there.

Kind regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2013

Added on Oct 22 2013

#general-database-discussions

2 comments

1,222 views