Solution : https://service.sap.com/sap/support/notes/1922200 (SAP Service marketplace login required)
Summary :
SAP Note addresses a performance degradation issue whereby high-volume concurrent spooling to table TST03 impacts I/O performance, involving DBA_LOBS settings. DCONTENT column management via BasicFile or uncompressed SecureFile LOB causes extensive I/O loads, exacerbated by INSERT operations and specific wait events tied to Oracle’s handling of LOBs. For resolution, enabling LOB compression (preferably 'low' due to minimal CPU usage increase and efficient storage within the ~3800-byte in-line threshold) using BrSpace tool is proposed. Medium to high compression settings are discouraged.
Key words :
output management priority recommendations / additional info category performance validity, terms oracle securefiles tst03 temse spool print performance reason, cache buffer chains''buffer busy waits''enq, __%pdfstyle%__ / } symptom performance degradation due, sap systems 2138262 oracle database 12c advanced compression, customer component bc-db-ora oracle, lob compression type 'low' greatly reduces, table_name column_name sec compre -------------------- -------------------- --- ------ tst03 dcontent, 1436352 oracle database 11g advanced compression, components bc-ccm-prn print
Related Notes :
| 1436352 | Oracle Database 11g Advanced Compression for SAP Systems |
| 2138262 | Oracle Database 12c Advanced Compression for SAP Systems |