on 04-19-2012 4:10 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Mamun,
Please have a look on following doc and SAP note regarding Online Table Reorganization.
Note 541538 - FAQ: Reorganization
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.