Skip to Content
avatar image
Former Member

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

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

m29z9.png (121.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • avatar image
    Former Member
    Feb 03, 2017 at 08:45 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 03, 2017 at 06:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 03, 2017 at 09:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2017 at 10:51 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2017 at 10:53 AM

    Hello All,

    Our environment is

    AIX : 7.1

    Oracle 12c

    EHP8 for ERP6. 0

    Regards

    Subbu

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 06, 2017 at 12:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2017 at 07:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 08:23 AM

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

    BR, Sergo.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2017 at 01:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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