Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> Compressing the Tablespace without Increasing the Size
post Aug 17 2017, 02:02 PM
Post #1


Group: Members
Posts: 1
Joined: 17-August 17
Member No.: 52,122

Our Oracle production database ( running on Linux has a Tablespace which consists of two datafiles (stores Application Audit log not DB audit logs) one with 31GB which is 100% full and other new datafile has been added with 10GB autoextend to maxsize of 20GB (in which 8GB has already been used out of 20GB).

The application audit log table was created on 2014. The database is growing drastically since a month and the retention they want to keep is for 7 years. Whenever they run a report, they want the data from the past 7 years to be accessed.

Is there any way that these application audit logs can be moved from database and kept at OS level by archiving them or any other methods where the database growth comes down by compressing?
Go to the top of the page
+Quote Post
post Aug 18 2017, 04:39 AM
Post #2

Advanced Member

Group: Members
Posts: 13,529
Joined: 26-January 04
Member No.: 13

Hi Sowji, and welcome to the forum!

I'm not sure what you mean by archiving, and why you want to store the data outside of Oracle.

You can easily compress s tablespace with the "alter tablespace" command:


Oracle offers many types of data compression:


If you can clarify your question, I will be glad to help!

Good luck!

Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 22nd September 2017 - 05:21 PM