Database DataWarehousing (MOSC)

MOSC Banner

11g OLTP Compression

edited Jun 4, 2013 10:53AM in Database DataWarehousing (MOSC) 7 commentsAnswered

Hi

We are evaluating 11g R2 advanced OLTP compression for one of our 24 x 7 OLTP database.
The table is quite large and has appx 4.6 billion rows and about 140 GB in size. The primary key is based on sequence
The table undergoes, inserts,updates and selects

Would this be a good candidate for OLTP compression? Since the table undergoes updates and inserts as well (besides selects), do we need to worry about the overhead for DML operations? Is there any test results out there where this features has been tested for DML operations? How much of an overhead is involved for such operations? Can we expect slowdowns in performance because of this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center