My Oracle Support Banner

" Library Cache: Mutex X " On Koka Cursors (LOBs) Non-Shared : (Doc ID 758674.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.


In testing prior to going to 11g, you find that application procedures which had completed in Oracle 10g in  minutes (e.g. 30-40 ) are now taking 12 hours or more ... or may not complete at all

Symptom #1

Using Oracle 11g with Automatic Memory Management you may find within a short amount of time CPU Utilization reached up to 100% and detected unusual Wait Event stats for 2 or more of the following: 

Symptom #2

Exceptional time spent for one of the following

Symptom #6



Testing or usage after upgrading to 11.1.0.x from 10g or earlier

Using or switching to CHAR NLS_LENGTH_SEMANTICS vs. the default value of BYTE

Comment: NLS_LENGTH_SEMANTICS is set at the Column level for Tables, Views, Indexes, or Packages/Procedures for Sting based datatypes including [N]CHAR ; [N]VARCHAR2 ; [N]CLOB


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.