on 02-03-2017 2:50 PM
Do it first on a Sandbox server. This is too risky for you to do the first time on a production server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harish,
yes it can be done online through conversion, but it is another story, we just spoke about Table Reorg 🙂
BR, Sergo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All,
Our environment is
AIX : 7.1
Oracle 12c
EHP8 for ERP6. 0
Regards
Subbu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.