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
liamadherne
Messages: 40
Registered: March 2008
Location: Philadelphia
Member
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.

Regards,
Liam.
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: 64109
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).

Regards
Michel

Re: tablespace is 92% used. [message #317807 is a reply to message #317743] Sat, 03 May 2008 16:54 Go to previous message
rlockard
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.

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


Current Time: Mon Dec 05 08:30:38 CST 2016

Total time taken to generate the page: 0.06865 seconds