Table Scan:DBTABLOG reorg taking time

[Former Member]

Hi,

We are running Tables reorganization in our database Oracle 11g.

SAP is ECC 6.06 and OS is HP-UNIX.

For all tables reorg is running fast but inly table DBTABLOG is running from last 4 days.

Tables with more size than DBTABLOG completed but this is still running, We also deleted lot of data from DBTABLOG and reduced its size from 200 GB to 10GB but there is no growth in reorg speed.

while checking sql statements we analyzed for all tables reorg shows Rowid Range Scan -

3085

100 %

4/2/2015 12:57:05 AM

0

Rowid Range Scan:  SAPR3.ZZGLFUNCA: 82570 out of 82570 Blocks done

161

But only for DBTABLOG it shows Table Scan -

2071

2 %

4/2/2015 4:10:04 AM

565068

Table Scan:  SAPR3.DBTABLOG#$: 146969 out of 7544755 Blocks done

11226

Not sure if this could be reason of slow reorg of this table, Please provide your opinion if this could be reason or what could be other possible reason and how can we resolve it.

Thanks,

Shivam

[former_member182967]

Hello Shivam,

If you do not take much care about the table change log data, why not delete it.

Refer to  41300 - Table DBTABPRT is very large

Regards,

Ning Tong

[JamesZ]

Hi Shivam,

4 days for 10GB segment reorganization is really slow.
Did you use brtools to reorganize DBTABLOG? If so, please attach the brspace log.

Also please check database lock in ST04 to see if there is any database lock.

Best regards,
James

[former_member204746]

go see the size of table DBTABLOG.

it seems to be HUGE!