Skip to Content
avatar image
Former Member

online table reorg with brspace

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 19, 2012 at 05:46 AM

    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,


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2012 at 05:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 19, 2012 at 07:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded