Last updated on JANUARY 14, 2015
Applies to:Oracle Warehouse Builder - Version 220.127.116.11 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:
Top 5 Timed Foreground Events
|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|
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 hundreds of Community platforms