Oracle Database Reorganization

[former_member199694]

hi,

Planning to reorg oracle database for apo. This involves transparent tables and also cubes. Is there any SAP recommended Oracle reorg strategy / guide for doing so.

would appreciate any detailed guide is available.

Thanks,

RajS

[Former Member]

Just make sure you don't run any data loads during the reorganization. APO and BI jobs can change indexes or partitions and this will interfere with your reorgs. So all jobs with DDL actions must not be running at that time.

But selects and DML are allowed during the reorg.

Cheers Michael

[former_member264034]

Hi,

You can perform online database reorg on APO system. An online

reorganization is online per definition, so it doesn't interfere on a

logical consistency layer with other system components.

The online reorg need additional CPU, disk space and other system

resources. If possible, we do not recommend to do the online reorg when

you have heavy workload on the system.

If you want to understand more about BRSPACE online reorganizations

please refer to following online help topics.

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/32/

0d0c888839164ba4245b3ff7969c59/frameset.htm

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/1b/

4e8f0d38a8f4419436d608a36b6581/frameset.htm

Regarding the offline reorganisation, please check the below:

SAP Note 646681 (offline-reorganization in Remark14 of this note).

Please see point 14 in the above note which clearly explains the

offline reorganisation process.

541538 FAQ: Reorganization

647697 BRSPACE - New tool for Oracle database administration

648753 Reducing the tablespace size with a reorganization

Regards,

Aidan