% DB increase differs for two system from the same landscape

[Former Member]

Hi all ,

I have done upgrade and then unicode conversion for the two system- sandbox and development from 4.6 C to ECC 6.0 with oracle 10 G and AIX 5.3

On sandbox % db( used db size in DB02 ) increase is 60 to 80 which is as per SAP figures after unicode conversion however on dev it is almost 150 % .

Has anybody faced the same problem before or can you suggest somthing for this tremendous data growth

Also what I have observed is threre are 7 tablespace on sandbox and 8 on Dev with "PSAPSR370" as the additional one on DEV ( PSAPSR3700 is different )

Please help me on this

-Ganesh

[Former Member]

Hi Ganesh,

the database growth depends heavily on the content. Which languages do you have installed in your system and which  modules are used by your company?

I think the normal growth should be in a range of zero to 30 percent. The lower end comes from the reorganization effect due to the migration and 30 percent comes due to the fact that most data is normally numeric and numbers are the same with or without Unicode. But in rare situations it could be possible to see much higher values. The reason is, that Oracle, and also DB2, are using UTF-8 encoding if you're running your system as Unicode system. In UTF-8 a two byte Unicode character could be encoded in up to four bytes. That means if your systems contains lots of double byte characters it could grow much more than 30% but it seems unusual to me.

Are you sure that nothing was wrong with your migration?

Best regards

Ralph Ganszky