Solved

Oracle data compression in 11G R2

Posted on 2013-06-05
3
304 Views
Last Modified: 2013-06-11
Dear All,

I just read about data compression techniques in 11GR2,

I understand like even DML operations can be done without much performance issues.

I wanted to know, is there any specific scenario, where I should not use compression.
0
Comment
Question by:sakthikumar
3 Comments
 
LVL 13

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 500 total points
ID: 39222167
0
 
LVL 7

Expert Comment

by:Docteur_Z
ID: 39224823
Beware : Advanced Compression is a paying option
0
 

Author Closing Comment

by:sakthikumar
ID: 39238940
I still didnt get a clear picture, whether to go or not to go for compression.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Insert and update a row at the same time 4 49
passing parameters to sql script oracle 4 26
selective queries 7 21
Oracle 10g standard edition server with 4 processors 3 29
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now