Full Optimize - Space needed in BW/Oracle

[Former Member]

Hi.

This is kind of a SAP basis question, I think. We are doing full optimization, which eventually ends in an ABAP dump indicating that the Oracle database is running out of table space.

We have had similar problems before, and just had the Oracle DBA extend the table space.

It is obvious that Full Optimization need to do a lot of work in restructuring and recreating the application set. The question now is how much table space is needed to do a full optimize? Is it possible to estimate?

The DBA doesn't want to set AutoExtend on the database table space. Does anyone know best practice on this matter of subject?

We are running SAP BPC 7.5 SP07.

Kind regards

Mogens Smerdel

[Former Member · Accepted solution]

I cant give a specific answer as i am not a basis expert but can help you understand the full optimize process.From a technical point of view,the cube is restructured and the dimension combinations are reviewed based on the fact table ratios.

So this process creates some temporary tables and then finally a new cube is created .

You might have to look at the current cube fact tables and no of dimensions (tables) and make an estimate of the size and structure .

Regards,

Sachin

[Former Member · Accepted solution]

Hi Sachin.

Thank you for your explanation..

Do you know an easy way to get the size of the fact and dimension tables.. Or is it just doing some manual calculations based on row width x row count?

Regards

Mogens

[Former Member · Accepted solution]

Hi Mogens,

This SDN guide should help with the size of the tables.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0427b8a-7fe5-2c10-f1be-a8be71fa2...

Cheers,

Sachin

[Former Member · Accepted solution]

Thanks..