Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Long time reorganization table

Hi Support

I tried to run the table reorganization of 128 GB, this run takes 15 hours.

Brtools run this reorganization, the options used were:

- brtools

- (3)

- (1)

- BRSPACE options for reorganization of tables

1 - BRSPACE profile (profile) ...... [initRQ1.sap]

2 - Database user/password (user) .. [/]

3 ~ Reorganization action (action) . []

4 ~ Tablespace names (tablespace) .. []

5 ~ Table owner (owner) ............ []

6 ~ Table names (table) ............ [GLPCA]

7 - Confirmation mode (confirm) .... [yes]

8 - Extended output (output) ....... [no]

9 - Scrolling line count (scroll) .. [20]

10 - Message language (language) .... [E]

11 - BRSPACE command line (command) . [-p initRQ1.sap -s 20 -l E -f

tbreorg -t "GLPCA"]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


BR0662I Enter your choice:

BR1001I BRSPACE 7.00 (41)

BR1002I Start of BRSPACE processing: sehujakt.tbr 2012-02-01 16.11.59

BR0484I BRSPACE log file: /oracle/RD1/sapreorg/sehujakt.tbr

BR0280I BRSPACE time stamp: 2012-02-01 16.12.03

BR1009I Name of database instance: RD1

BR1010I BRSPACE action ID: sehujakt

BR1011I BRSPACE function ID: tbr

BR1012I BRSPACE function: tbreorg

BR0280I BRSPACE time stamp: 2012-02-01 16.12.08

BR0657I Input menu 353 - please enter/check input values

-


Options for reorganization of tables: SAPRD1.GLPCA (degree 1)

1 ~ New destination tablespace (newts) ........ []

2 ~ Separate index tablespace (indts) ......... []

3 - Parallel threads (parallel) ............... [1]

4 ~ Table/index parallel degree (degree) ...... []

5 - Create DDL statements (ddl) ............... [yes]

6 ~ Category of initial extent size (initial) . []

7 ~ Sort by fields of index (sortind) ......... []

8 - Table reorganization mode (mode) .......... [online]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-


and its execution was 15 hours

Now this same process we have to do in production, the table has 329GB

GLPCA approx.

This table is archived run now do the reorganization is required to

restore the real space in the table.

I need to run this reorganization with the best option from Sete to avoid

the high execution time of 15 hours in quality, because on average

production would be 35 hours in such execution to this table and not so

far achieved the best way to try to reduce the execution time for this

process of reorganization.

Thanks for your attention, I look forward to your comments

Regards

Former Member
Not what you were looking for? View more on this topic or Ask a question