Skip to Content
0
Jun 29, 2009 at 09:28 AM

Table increase with reorganization

313 Views

Hello,

We are experiencing troubles with online reorganization of tables on our BI7 with oracle 10.2.0.4 with brspace since the size of our tables after the reorganization is bigger than before.

Our SAP system is at the following level:

Software component Release level

SAP_ABA 700 14

SAP_BASIS 700 14

ST-PI 2005_1_700 6

PI_BASIS 2005_1_700 14

SAP_BW 700 16

FINBASIS 600 7

BI_CONT 703 8

SEM-BW 600 7

ST-A/PI 01K_BCO700 0

The system is running under HP-UX B.11 at the release B.11.23 and with a kernel at the level 150.

The oracle patch 10.2.0.4 has been set thereu2019s one month ago.

We did not experienced that problem before the setup of the new oracle patch.

These are the parameters for one of our table, we reorganized and for which the table increased after the operation:

Options for reorganization of tables: SAPR3./BIC/EZDAYSLS1 (degree 1)

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

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

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

As a result, the table increased from 8 413 184 KB , 1 051 648 blocks and 287 extents, with 10% of free in used blocks to 10 071 616 KB, 1 258 952 blocks and 285 extents with 0% of free in used blocks.

As we have to get some place into our database in order to prepare future increases of tablespaces in our production system, do you know what we do wrong or what need to be changed?

Thanks