Solution : https://service.sap.com/sap/support/notes/1166242 (SAP Service marketplace login required)
Summary :
Users encounter long wait events labeled "enq: HW contents" during LOB segment inserts when both the table and the LOB segments reside in an ASSM tablespace. This issue, identified by Oracle bug 6376915, affects versions 9.2.0.8 through 11.2.0.x. Post upgrade to 10.2.0.4 and subsequent SAP Bundle Patch installation, these wait phases can reoccur. The resolution involves applying the Oracle patch set 10.2.0.4 and setting event 44951, which controls the preallocation of LOB chunks to minimize wait times. For earlier versions, a backport may be requested. Additionally, changing LOB storage from RETENTION to PCTVERSION provides a temporary fix.
Key words :
long waiting phases occur, current kts merge fix, sql> alter table <owner>, sql> alter table sapsr3, sap bundle patch sap_102044_201005, sap bundle patch, sap customer message, event event='44951 trace, oracle patch set 10, long wait events
Related Notes :
| 1491797 | SLOW INSERT ON LOBS WHEN USING RETENTION AND SBP > 201005 |
| 949737 | Generating screen & CUA loads in own LUW |
| 745639 | FAQ: Oracle enqueues |