Solution : https://service.sap.com/sap/support/notes/10551 (SAP Service marketplace login required)
Summary :
The table TST03 and its corresponding tablespace are increasing in size continuously due to its usage for storing spool data, specifically in LONG RAW fields. Various SAP releases have had different byte limits for these fields, and kernel patches have introduced optimizations to reduce chained row processing when the PCTFREE parameter is set correctly. If initrans is improperly set, it should be corrected to 1 to ensure better space usage. Reorganization and manual cleanup of the tablespace are necessary if the storage requirements are not met. Switching the storage of spool data from the database to the file system can also mitigate the issue but comes with its own advantages and disadvantages.
Key words :
-> tools -> aministration-> monitoring -> performace-> database -> tables/indexes, bean incorrect initrans parameter setting, action affects newly allocated blocks, column segment_name format a20select segment_name, press 'detailed analysis'enter table, tablespace add datafile '<filename>' size, dba_extentswhere tablespace_name = 'psapprotd'group, table tst03 stores spool data, analysis'select 'detailed analysis', long raw database fields
Related Notes :
| 140547 | Adjust line length in the TST03 database |
| 19706 | Tuning the Spooler |