Solution : https://service.sap.com/sap/support/notes/1588876 (SAP Service marketplace login required)
Summary :
Oracle bug 10411618 introduces an enhanced mutex waiting mechanism in the Oracle Database, providing three configurable wait schemes to optimize concurrency. This adjustment allows system administrators to influence mutex waits by selecting from three approaches: yielding the CPU on all waits, sleeping for a fixed period, or using an exponential backoff strategy where wait times progressively increase. The patch addresses existing bugs and is included in the Oracle 11.2.0.2.2 PSU with additional fixes in subsequent patches. Administrators should be cautious about dynamically changing the mutex wait scheme to avoid potential issues, and should adjust settings according to the specific patched version applied to their system.
Key words :
_mutex_wait_scheme = 1_mutex_wait_time = 10the patches, set underscore parameters _kgl_mutex_wait_timeand /, milli-secondso _mutex_wait_scheme = 2 & _mutex_wait_time =, maximum sleep time set, mutex wait scheme dynamically, 3_mutex_wait_scheme = 1_mutex_wait_time = 10windows, 3_mutex_wait_scheme = 1_mutex_wait_time = 10note, fix effectively supercedes, prerequisites wait schemesthe, _mutex_wait_scheme = 1_mutex_wait_time = 4win 11
Related Notes :
| 1527505 | Oracle 11.2.0.2 underscore spare parameter |
| 1503709 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.2 |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |
| 964344 | FAQ: Oracle mutexes |