Exadata General (MOSC)

MOSC Banner

HCC and parallel

edited Sep 20, 2016 2:38AM in Exadata General (MOSC) 3 commentsAnswered

Hello,

we use an Exadata X3-2 with January 2014 patch and all software of version 11.2.0.4. Imageinfo shows 11.2.3.3.0.131014.1.

We have one big OLTP compressed table CALLS_00. It has about 2K partitions and contains calls records CDR, original size is 2811g for September and 2980g for October.

We compress it into HCC and we have strange results: for different parallel we have a very different HCC size.

We compressed the September in Archive High:

for 8 parallel slaves we've got 394g HCC AH size

for 32 parallel slaves we've got 718g HCC AH size

for 64 parallel slaves we've got 1400g HCC AH size

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center