on 02-18-2014 5:11 AM
Dear Experts,
Our Production Database(Oracle 11.2.0.3) is growing at a high rate.
We need to reorganize the highly growing tables. For a testing purpose we started in our test system.
During reorganization of SOFFCONT1 table(corresponding lob segment is SYS_LOB...7$$) in database, we get the below error:
We had tried increasing the PSAP<sid> tablespace by 5 GB but still its showing the same error.
Currently it is having 23 GB free space
Please suggest how do we go about it...
Regards
Imaan
Please attach output of below commands (preferable as attached files):
brspace -f dbshow -c tbinfo -t SOFFCONT1
brspace -f dbshow -c tsinfo -s PSAPPRD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Roman,
You are right, before Reorg to be done, the tablespace should contain minimum twice the size of table to be reorged.
As per link :
Thank you all for the guidance...
Hi,
Please use the below command and reorg once again.
This should solve your issue.
brspace -u/-f tbreorg -t <table_name> -a cleanup
Regards
Yugandhar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
First update the BRTools if you are on a lower version or patch level.
Secondly refer to these SAP notes and delete the data from the table SOFFCONT1 which are no longer required before you do a table reorg.
1634908 - Reduce the size of table SOFFCONT1
966854 - Reorganization - New report
The best option would be to do an export and import of the table using BRTools.
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Reagan,
Thanks for the information :
1-> Our brtools was recently upgraded to BRTOOLS 7.20 (33) with kernel 720 Ext.
2-> I have already executed the reorg reports as per SDN - http://scn.sap.com/thread/3178083
Our entries got reduced from 2,915,342 to 2,474,262.
Can you please let me know any notes for export & import of tables. Also please explain how this will help in reducing the data.
Regards
Imaan
Hi Imaan,
Please follow SAP Note 1431296 - LOB conversion and table compression with BRSPACE 7.20
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What is your SBP version? There is known bug with brspace command (reorg).
Apply latest SBP and then retry.
We encountered this during our ACO enablement, we had to move this table to new table space without reorg to complete the activity.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Unfortunately it is not reported in any of SAP notes (related ACO known issues).
There are solutions to apply:
1) Execute this and confirm the result:
brspace -u / -f tbreorg -a reorg -t SOFFCONT1 -ic sap_proc -l 2 -p 4 -e 16 -KST -FPM
2) Exp/Imp table using brspace
3) Update latest SBP and then do online reorg.
Regards,
Nick Loy
Hi Imaan,
I am sure that same bug is hitting you, now you left with 2 solutions.
1) Update latest SBP and then try to reorg the SOFFCONT table
2) Exp/imp table using brsapce command
You must have got below errors in Oracle trace file.
ORA-03113 disconnection during reorganization of soffcont1 table
This error is typically linked to a segmentation fault on Oracle server side (ORA-07445 related to a memcpy routine) and it is resolved in latest SBP.
Regards,
Nick Loy
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.