Dynamically increase the number of parallel process while performing table reorg using BRTOOLS

[SAPSupport]

While performing table reorg on a particular table using BRTOOLS, can we dynamically increased the number of parallel process (parallel degree) allocated for that particular table?

Can we perform table reorg and index rebuild activity simultaneously using BRTOOLS?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear customer,

Q1: While performing table reorg on a particular table using BRTOOLS, can we dynamically increased the number of parallel process (parallel degree) allocated for that particular table?

A1： According to note 646681, there are two levels of parallel processing for the reorganization process in BRSPACE:
1. Parallel processing at BRSPACE level using several threads
2. Parallel processing at DBMS_REDEFINITION package level

Current parallel you mentioned is point 2. This is an internal Oracle parallel processing that uses the parallel query feature during the data copy process. This means that parallel processing is carried out during the reorganization of individual tables. This type of parallel processing is recommended if a few large tables are reorganized. The parallel processing level is specified here in the option -e|-degree. As the option -e could not be changed during a reorg, so it cannot be changed dynamically.

Q2: Can we perform table reorg and index rebuild activity simultaneously using BRTOOLS?

It is possible to do so but it may consume resources and result in unexpected performance issue. We do not recommend you to do so.

Best regards

Jackie