Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
Sowji
post Aug 17 2017, 02:02 PM
Post #1


Newbie
*

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



Our Oracle production database (11.2.0.4) 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
burleson
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:

http://www.dba-oracle.com/t_tablespace_compress.htm

Oracle offers many types of data compression:

http://www.dba-oracle.com/oracle11g/sf_Ora...or_the_DBA.html

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