Date: Sun, 12 Oct 2008 17:54:14 -0500
Audits are being turned on in some of our systems. A third party tool is going to be auditing OS and database information and collect the information in their repository (another Oracle DB).
They have recommended that audit go to DB, so the tool can pull the
information out of audit table. I am concerned about the location of audit
table AUD$. In previous projects we have moved the table out of system
But it is not supported by Oracle it seems. How do you all handle the growth of the audit table?
- Move Audit table to another tablespace. How do you handle the upgrades.
- Periodically make a copy of the table into a history table and then truncate it. I will have to find out if the product truncates it. I will be worried if for some reason the copy/truncate by the auditing product does not happen.
- Let the table sit on the on system tablespace and grow as big as it can get and allocate all the space it needs.