My Oracle Support Banner

Bug 17768168 : Automatic Storage Management (ASM) Slow File Allocation (Doc ID 2120915.1)

Last updated on DECEMBER 25, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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.



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

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