on 06-25-2014 11:57 AM
Hi ALL,
Oracle version 11.2.0.3
BRTOOLS 7.20 (30)
SAP version 7.2
The below LOB segment which is more occupied space in CRM
system and I checked with any compression option but my bad as per As per SAP note 1431296 SAP
recommendation not to compress the following table in oracle and if these tables have securefile LOBs, we
should also not compress them.
The below object which is securefile LOB so we don’t have
any option for compression.
Is there any option available for archiving or deletion the old data’s? Can we make use of them?
Is it any impacting business data?
SELECT table_name, column_name,securefile, compression FROM dba_lobs where SEGMENT_NAME='SYS_LOB0000337570C00008$$';
TABLE_NAME COLUMN_NAME SECUREFILE COMPRE
FEH_MESS_PERS PAYLOAD YES NO
SEGMENT_NAME | SEGMENT_TYPE | Size in GB | TABLESPACE_NAME |
SYS_LOB0000337570C00008$$ | LOBSEGMENT |
| PSAPSR3 |
Please let me know if any more details.
Thanks & Regards,
Dhavan
Hi Dhavan,
You need to first clear old records either by means of archiving or deletion process supported by SAP.
Post this you may Reorg the table which will inturn shrink the LOB segment as well.
For Archiving you may use archiving object: /SAPPPO/PPO
There is a report /SAPPO/DELETE_ORDERS which deletes the orders including the two payload tables FEHT_MESS_PERS and FEHT_MESS_REF. The payload of PPO orders that were previously deleted must be removed from the system individually.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
Maybe this is because the here under note is not applied on your system.
Can you please confirm the size of the Secufrefile, is it 445 Gb (SCN automatic formatting option has added a "1." to the number)
Using SecureFile compression is not forbidden on SAP system, you could activate a low compression on that segment.
Regards
1731230 - /SAPPO/DELETE_ORDERS: FEHT_MESS_PERS is not deleted
1818320 - Oracle 11g Advanced Compression for LONG data restriction
SecureFiles Compression LOW, new in Oracle Database 11g Release 2, is optimized for high performance. SecureFiles Compression LOW actually maintains about 80% of the compression achieved through MEDIUM, while utilizing 3x less CPU.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.