Problem oracle query access slow from install oracle interim patch 9558995

** Myself,team,Note
Cause
For inserts in LOB segments, long wait events "enq: HW contents" occur if the relevant table and the LOB segments are created in an ASSM tablespace (TBS) Table TST03,VBDATA.
Change the storage option of the LOB from RETENTION to PCTVERSION.
SQL> alter table <OWNER>.<TABLE NAME> modify lob (<LOB NAME>) (pctversion 10);
For
example, for table TST03:
SQL> alter table SAPSR3.TST03 modify lob (DCONTENT) (pctversion 10);
Result if Don’t apply
# long wait events and slow write table TST03,VBDATA

Result After rollback Patch and reduce pctversion storage option
# Normal operation

Step remove Interim patch
1. Stop database and listener (by ora<sid> user)
SQL>shutdown immediate;
lsnrctl stop
2. Deinstall interim patch 9558995 on (by ora<sid> user)
#cd /<Patch_Base_Path>/SAP_102044_201005/9558995
#$ORACLE_HOME/OPatch/opatch rollback -id 9558995

3. Check interim inventory report
#$ORACLE_HOME/OPatch/opatch lsinventory
4. Startup database (by ora<sid>user)
SQL>startup;
5. Startup listener (by ora<sid>user)
lsnrctl start
6. Check oracle process and listener
ps -ef|grep smon
ps -ef|grep tns
7. Check listener
tnsping <SID>



Step Change the storage option of the LOB from RETENTION to PCTVERSION.

Change option access PCTVERSION (sap tables) object blob column problem
access slow TST03 , VBDATA
SQL> alter table <OWNER>.<TABLE NAME> modify lob (<LOB NAME>) (pctversion 10);
For
example, for table TST03:
SQL> alter table SAPSR3.TST03 modify lob (DCONTENT) (pctversion 10);
SQL> alter table SAPSR3.VBDATA modify lob (VBDATA) (pctversion 10);