The Oracle DB is configured to use a filesystem created over lvm volume. This
LVis created on top of RAID 10
mdraiddevice set up using
nvmedisks. As soon as the Oracle DB starts
ASYNCIO operations, there are large number of
kworkerprocesses created and system load average increases significantly. This also results in a severe IO performance issue.
filesystemio_options=SETALLalso causes similar issue, since this option in DB would allow it to use
ASYNCIO operations on above filesystem, lvm volume created on
In some occurrences these
kworkerprocesses will keep hogging CPU usage for about 30 minutes even though there's no more running workload.
- Red Hat Enterprise Linux 7.4
XFSfilesystem created on lvm volume using
RAID 10set up created using
- Oracle database configured to use
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.