on 10-05-2017 7:12 AM
Hi All,
As we noticed In SAP PI System PSAPSR3DB Table space is drastically increasing and irrespective of adding 250 GB space additionally still table growth is occupied 86% as shown below.
Please help us the way to reduce the PSAPSR3DB LOBSEGMENT Space.
Regards,
Kesava.
Dear James,
Thanks q So much for your suggestion. I will suggest my DB team to implement the same.
Kindly suggest on my below query. As we are not able to solve this from past one month. Due to this we are not able to perform any production activity in smooth way.
Issues we are facing
In SAP PI System PSAPSR3DB Table space is drastically increasing and irrespective of adding 700 GB space additionally still table growth is occupied 90%.
I asked DB team to perform the RE-ORG activity in table (PSAPSR3DB- BC_MSG)for getting the extra used space in the segment level. While performing this activity DB team is facing the below error. There are un able to resolve this this and table space is keep increasing. Please suggest us the way to come out from this issue.
""
ORA-00955: name is already used by an existing object
BR0280I BRSPACE time stamp: 2017-10-06 00:11:24
BR1106E Reorganization of table SAPSR3DB.BC_MSG failed
""
Regards,
Kesava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kesava,
This could be oracle bug 26729494, for the details please refer to SAP note 2538588.
If the workaround does not work, please contact SAP support by mentioning this note.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
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.