Showing results for 
Search instead for 
Did you mean: 

online table reorg with brspace

Former Member
0 Kudos

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


Al Mamun

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos


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



Former Member
0 Kudos

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

Active Contributor
0 Kudos

hi Mamun,

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


BRSPACE Online Reorganization

Note 541538 - FAQ: Reorganization