cancel
Showing results for 
Search instead for 
Did you mean: 

Reorganization

Former Member
0 Kudos

What does SAP recommend regrding the Reorganisation of Large tables what precautions we need to take whether it is online or offline.

Please help me

Thanks,

XYZ

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi XYZ

What is a large table for you?

Consider

- do we have a backup if everthing goes wrong (should be an automatic: off course)

- Rollback / Undo, is there enough space, you will need approx table size more undo

- test reorgs on smaller tables on a test box, if possible do a large table too

- Parallel Execution: if you have enough cpus and spfile parallel_max_servers is set accordingly do specify parallel in brspace. Careful there are two options:

3 - Parallel threads (parallel) .......... [1] <---- Reorgs multiple tables concurrently

4 ~ Table/index parallel degree (degree) . [] <---- You should use this one!!!

I also support the above statements concerning off peak hours and long raw fields.

Regards

Michael

Former Member
0 Kudos

<b>Rollback / Undo, is there enough space, you will need approx table size more undo</b>

Correction: i think my remark concerning undo is wrong, an online reorg creates the new object as temp segment, there is no undo involved, but you will need approx the table free space in your target tablespaces - sorry for that.

Regards Michael

Former Member
0 Kudos

Hi,

you should put large tables on dedicate tablespace to better manage extents.

starting with oracle you can reorganize tables online except those with LONG RAW columns. this limitation has gone with 10g as you can convert LONW RAW to BLOB using ONLINE reorg but old SAP kernel dont support this conversion.

the good aproach is:

Reorg tables without LONG RAW during No Peak Hours you can do that with SAPDBA or BRSPACE.

Reorg tables with LONG ROW with export/import procedure. you need to stopsap to reorganize them

Thanks