Unicode UTF8

[Former Member]

Hello all,

we are using SAP R/3 Enterprise 4.7 wit database Oracle 9.2.x.

Begin of this year we have migrated to Unicode UTF8..

Due to serveal purposes we are planning to migrate to MaxDB next year.

Our current Oracle-DB size is about 250 GB. ( plus QAS + DEV ).

Big tables are for e.g.

GLPCA (data: 16 GB, index: 9 GB), PPOIX (data:10 GB, index: 12 GB),

COEP (data:8 GB, index 3 GB), RFBLG (data: 7 GB, index: 0,5 GB).

Now my questions:

1) I have read a SAP document with message:

migrate to MaxDB with UTF16 means additionally disk space ( 40 - 60 % )

Is this more or less realistic ? ( I heard up to 100 % )

2) I read the new features of MaxDB 7.7. There is a kernel parameter

"useunicodecolumncompression = YES"

the system uses UTF8 for Unicode, except for key columns

Does this means that indexes will migrate to UTF16 and data to UTF8 ?

So the totally increasing will be about 20 - 30 % ?

3) MaxDB 8.0 can use UTF8.

When the realease time, approximately ?

Thanks for your answers in advance.

Regards, Reinhard

[TTK]

Hello Reinhard

Customers reported that the size of Oracle DBs might be larger than the same data in a MaxDB (see e.g. <a href="http://maxdb.sap.com/events/MaxDB_Infoday_2007/K1_2007_MaxDB%20in%20der%20GESIS-Systemlandschaft.pdf">GESIS-Systemlandschaft.pdf</a>). This could balance your demands a bit.

ad 1)

Of course, the numbers depend on the data. The given 40-60% are expectations.

ad 2)

I would answer the question with yes. However, how do you come up with 20-30%? Is there an index on every second Unicode character column?

ad 3)

Neither I know nor I can answer anything about 8.0.

Regards Thomas