SAP Note 140547 - Adjust line length in the TST03 database

Component : TemSe (Repository for temporary sequential objects) -

Solution : https://service.sap.com/sap/support/notes/140547 (SAP Service marketplace login required)

Summary :
The SAP Note addresses the issue of table TST03 growing excessively in size, particularly with the Oracle database, due to inefficient space utilization caused by an unfavorable setting of the LONG RAW data field length. A kernel patch modifies the length parameter to minimize wastage. Users must manually adjust the PCTFree value to 1% through transaction SE11 and reconfigure storage parameters for changes effective post Release 4.5B. These changes are not transportable and must be applied individually per database. Additionally, adjustments only affect newly generated lines, not pre-existing ones. For issues like ORA-25150 error, direct SQL commands are recommended.

Key words :
call transaction se11 -> utilities -> database utility -> edit -> storage parameters, transaction sp12 -> temse data storage -> memory allocation, 0b patch level 309the changed block size, transaction db02 -> detailed analysis, 1i patch level 218release 4, long raw data field, alter table sap<sid>, transaction se11 terminates, long raw field, transaction se11

Related Notes :

48400Reorganization of TemSe and Spool
24374Structure of table TST03
19466Downloading SAP kernel patches
10551Table TST03 grows