Home » RDBMS Server » Server Administration » tablespace is 92% used. (10G/Unix)
tablespace is 92% used. [message #317743] Fri, 02 May 2008 23:58 Go to next message
Messages: 40
Registered: March 2008
Location: Philadelphia
Hello Eeverybody

While checking the free space in the DB, I came across one tablespace (AUDIT_TB) which is 92% used.
This tablespace contains one table(AUD$) and one index.

Is it safe to purge the mentioned table or index to make the tablespace usage below 90%.

Appreciate your view n this.

Thanks for your time.

Re: tablespace is 92% used. [message #317748 is a reply to message #317743] Sat, 03 May 2008 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, it is safe to purge it.

Just a remark, SYS.AUD$ out of SYSTEM tablespace is not supported (altough documented in Metalink).


Re: tablespace is 92% used. [message #317807 is a reply to message #317743] Sat, 03 May 2008 16:54 Go to previous message
Messages: 19
Registered: April 2008
Location: Baltimore, MD
Junior Member
Before you purge sys.aud$ better check on policy. I always backup the table before cleaning it out.

This is your audit table and purging it could cost you your job. I fired one dba for cleaning out sys.aud$ without getting the customers blessing.

But can you purge sys.aud$? Yes you can. Do you really want to do it? Check with the owner of the data.

Previous Topic: ora-00600 error in alert log file
Next Topic: Always connected to an idle instance
Goto Forum:

Current Time: Mon Oct 24 17:37:42 CDT 2016

Total time taken to generate the page: 0.10133 seconds