cancel
Showing results for 
Search instead for 
Did you mean: 

Online DB reorg for Cluster table RFBLG in Production system - Urgent Please

former_member190251
Participant
0 Kudos

Hello Team,

We are going to perform reorg for the cluster table RFBLG in our production environment.

Could you please conform whether cluster table reorg can be performed ONLINE ? and anything pre-requisite to be taken care.

Also let me know whether we can perform rebuild LOBINDEX online.

Regards
Subbu

Accepted Solutions (0)

Answers (9)

Answers (9)

Do it first on a Sandbox server. This is too risky for you to do the first time on a production server.

former_member190251
Participant
0 Kudos

Hello All,

We did the online reorg in Test box last sunday, but the size was increased after online reorg.

Before online reorg

RFBLG table was 99GB

After online Reorg

it size was increased and it is around 100GB

Regards

Subbu

Former Member
0 Kudos

Hi Subbu,

It's ok, share DB02 screen shot as above.

Here you did not compress your table you just did a reorg, check your table read/write time to compare the before after performance.

Regards,

Harish Karra

Former Member
0 Kudos

Hi Harish,
yes it can be done online through conversion, but it is another story, we just spoke about Table Reorg 🙂

BR, Sergo.

Former Member
0 Kudos

Yes,

Table reorg can be done online for any of the table, run time and performance impact can be measured by running it in non-prod system.

Sergo - Even old to new long raw conversion can be done online so it's a 2 step process but everything is online

Regards,

Harish Karra

Former Member
0 Kudos

You MUST test it on test/sandbox system first!
In General, everything can be reorged online except old LONG - RAW fields.
Try to read SAP NOTES regarding that first.

BR, Sergo.

former_member190251
Participant
0 Kudos

Hello All,

Our environment is

AIX : 7.1

Oracle 12c

EHP8 for ERP6. 0

Regards

Subbu

former_member190251
Participant
0 Kudos

Hello All,

I am little bit confused after gone through two below SAP notes

2169933 - Reorganization on SAP table pools and table clusters
646681 - Reorganization of tables with BRSPACE

Could you please confirm the below point.

Since RFBLG is cluster table , can we run it in ONLINE reorg or OFFLINE reorg in production system.

Note : Business will be running as usual and minimal number of users connected and doing transactions on Sunday.

Our environment is

AIX : 7.1

Oracle 12c

EHP8 for ERP6. 0

Regards

Subbu


Former Member
0 Kudos

Hi Subbu,

Online table reorg and Index rebuild is very much possible from Oracle 10g on. But requirement drives it.

Though it has benefits in terms of space reduction etc., it has few disadvantages too. Run time won't impact system performance a lot because you have an option to tune number of processes and threads using brspace command.

Regards,

Harish Karra

Matt_Fraser
Active Contributor
0 Kudos

Hi Subbu,

Questions about reorg or rebuild of tables and indexes can often be database-specific, as what might be appropriate in Oracle, for instance, may not be appropriate in SQL Server or DB2, etc. Are you using Oracle? That's my guess from your screenshot and the LOBINDEX query, but I'm not an Oracle expert, so I'm not sure.

For SQL Server (which is more my area), a reorg like this is generally not recommended, as it's not worth the time and performance impact upon your system for usually only fleeting gains. There are often better ways to improve the index performance on a table. But, I think with Oracle sometimes it might be considered helpful. Again, not my platform.

I recommend you do some searching, as there are many Notes, blogs, and previous forum questions about this. In general, an online reorg of RFBLG is probably possible, but it might take a very long time and use a ton of resources -- it might be better to consider an offline reorg for this particular table, due to how large it typically is.

References:

https://archive.sap.com/discussions/thread/3462580

https://archive.sap.com/discussions/thread/815820

https://launchpad.support.sap.com/#/notes/1431296/E

https://launchpad.support.sap.com/#/notes/1942183/E

https://archive.sap.com/discussions/thread/3870859

Cheers,
Matt