Using RDBMS 10.2.0.3: Have You Experienced Enq: Hwm - Contention?

From: fmhabash <fmhabash@xxxxxxxxx>

To: Oracle L <oracle-l@xxxxxxxxxxxxx>

Date: Tue, 05 Apr 2011 15:51:08 -0400

We go hit by this event recently and would like validate the scenario
and the proposed solutions against your experience if you encountered
it. This event affected a LOB segment in an ASSM tablespaces in a RAC
database.

This is what I have found so far ...
1) As temporary workaround, manually add extra space to the LOB segment.
2) Bug 6376915 (affecting 10.2.0.3)

- >= 10.2.0.4: EVENT="44951 TRACE NAME CONTEXT FOREVER, LEVEL < 1 -
1024 >"
- set PCTVERSION to 100: but never able to use blocks freed by
updated blobs

- Set FREEPOOLS is set to a value >= the number of instances
- Partition the table into a number of partitions sufficient
4) Try alter system set"_insert_enable_hwm_brokered"=false
If you did encounter this issue, what was you rca and final resolution?
Thank you.
--
http://www.freelists.org/webpage/oracle-l