Release Notes › Known Issues › General › Enable the Fix for Oracle Bug 6376915

Enable the Fix for Oracle Bug 6376915

The Oracle bug 6376915 causes high water (HW) enqueue contention when the database is busy handling large objects (LOB) and the database is configured to use automatic segments space management (ASSM).

This bug causes performance and scalability problems with CA software, including CA Identity Manager and CA CloudMinder.

The fix for this problem introduces a mandatory event. Set this new event to make the ASSM architecture allocate LOB chunks more efficiently.

This bug was introduced in Oracle 10.2.0.3. It was fixed in both Oracle 10.2.0.4 and Oracle 11.1.0.7. However, the fix is not enabled by default.

The steps in this procedure assume that spfile is used for configuration.

Follow these steps:

1. Enter the following command:

   ALTER SYSTEM SET EVENT='44951 TRACE NAME CONTEXT FOREVER, LEVEL 1024' scope=spfile;
   

2. Restart the database.
3. To test the fix, use the following measures:
   • Use Bulk Loader to measure the task throughput in CA Identity Manager and CA CloudMinder.
   • Measure the wait time for HW enqueue contention.