online table reorg with brspace

[Former Member]

I am planning to reorg a  200 GB  table online  with brspace with our production  system with the  command below

brspace -f tbreorg -a reorg - t table name

How about using -e 4 or 6  option for degree of parallelism using in productuon ?

it takes very long time to reorg without -e 6 ( or 4) as i have tried in QA

The table is heavily used and canot do off line reorg.

Your reply will be appreciated

Thanks

Al Mamun

[Former Member]

Hi,

consider the following bug before doing a reorg with parallel thread:

1514200 - Possible dataloss after long to lob conversion

On very high-end systems (20-30 physical CPUs, for instance) you could consider to use an higher parallelism. But you have to look at log_file_sync wait event. During normal operation it should be less than 15ms. If reorg online raise it to 100-200ms, end-users could experience slowness of the System.

Take a look at this note to learn more about Oracle wait events:

619188 - FAQ: Oracle wait events

Regards

Leo

[Former Member]

Hi Al Mamun,

>> How about using -e 4 or 6  option for degree of parallelism using in productuon ?

It depends to your installation, but as a rule of thumb more than 4 parallel processes does not speed-up your process.

Check the document, below and search for "Remark 13";

Note 646681 - Reorganizing tables with BRSPACE

Best regards,

Orkun Gedik

[former_member182034]

hi Mamun,

Please have a look on following doc and SAP note regarding Online Table Reorganization.

BRSPACE

BRSPACE Online Reorganization

Note 541538 - FAQ: Reorganization

Regards,