<div>
Should I have any reason to be concerned over messing with the system tablespace in this way? &nbsp;My instinct is a clear no, but I'm very open to hear others' concerns and experience with this, after all, it is the system tablespace! &nbsp;Thanks again.
</div>


Should I have any reason to be concerned over messing with the system tablespace in this way?  My instinct is a clear no, but I'm very open to hear others' concerns and experience with this, after all, it is the system tablespace!  Thanks again.

<div>
How does one choose to close a question and split points?
</div>


How does one choose to close a question and split points?

<div>
<div class="content wysiwyg-content">
When auditing in Oracle using aud$ (audit_trail = db), I am concerned about system tablespace fragmentation. &nbsp;There will be a few thousand $aud entries per day on the average database (with pretty limited auditing).<br />
<br />
I will be:<br />
<br />
(1)<br />
Offloading into text files or exporting the contents of the $aud table regularly.<br />
<br />
(2)<br />
Truncating weekly or nightly.<br />
<br />
I will follow Oracle's strict instructions to not move $aud into another tablespace despite the recommendations of a an Oracle author. &nbsp;I'll do audit_trail=os before doing that.<br />
<br />
Thank you.
</div>
</div>


When auditing in Oracle using aud$ (audit_trail = db), I am concerned about system tablespace fragmentation.  There will be a few thousand $aud entries per day on the average database (with pretty limited auditing).

I will be:

(1)
Offloading into text files or exporting the contents of the $aud table regularly.

(2)
Truncating weekly or nightly.

I will follow Oracle's strict instructions to not move $aud into another tablespace despite the recommendations of a an Oracle author.  I'll do audit_trail=os before doing that.

Thank you.

Auditing in Oracle with aud$, system tablespace fragmentation issues?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.