OWB 11g Control Center Service Hanging During OWB ETL Processing With Mutex Waits
(Doc ID 1316495.1)
Last updated on NOVEMBER 09, 2018
Applies to:Oracle Warehouse Builder - Version 22.214.171.124 and later
Information in this document applies to any platform.
These errors are usually found on RAC (Real Application Clusters) systems but can be found in single server environments.
Slow running OWB ETL processing.
Running the AWR reveals:
|Event||waits||Time(ms)||(ms)||Avg wait % DB time||wait class|
|cursor: mutex S||12,508,473||2,607||0||14.8||Concurrence|
|direct path read||106,521||2,498||23||14.2||User I/O|
|library cache lock||34,980||610||17||3.5||Concurrence|
|direct path read temp||22,933||198||9||1.1||User I/O|
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document