Bug 17768168 : ASM slow file allocation (Doc ID 2120915.1)

Last updated on JANUARY 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
DB CPU 50.9K 74.6
log file sync 99,459 2646.7 27 3.9 Commit
db file sequential read 326,157 1946.5 6 2.9 User I/O
direct path read temp 3,089,459 1088.9 0 1.6 User I/O
library cache lock 18,737 974.8 52 1.4 Concurrency
rdbms ipc reply 336 651.8 1940 1.0 Other
reliable message 17,046 635.1 37 .9 Other
direct path read 1,163,544 579.2 0 .8 User I/O
enq: IV - contention 83,161 529.6 6 .8 Other
enq: JI - contention 109 371 3403 .5 Other

File_name :: awrrpt_2_22108_22112.html

 

There was no OS level issue observed.

Database level queries were slow and ASM level it was generating diag trace files.

 

Cause

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