Newsgroups: comp.databases.oracle.server
From: Matthias Hoys <matthias.h...@gmail.com>
Date: Wed, 16 May 2012 01:32:51 -0700 (PDT)
Local: Wed, May 16 2012 4:32 am
Subject: Re: Slower performance after enabling async io on Oracle Linux
On Tuesday, May 15, 2012 8:05:53 PM UTC+2, Mladen Gogala wrote: It doesn't make any difference. Sysadmin checked everything between the guest/host and the iSCSI box, they didn't see anything wrong.
> Please, let us know what the outcome is. I am really curious now.
I now analyzed a long-running query (> 5 minutes) with a level 8 10046 trace. This is with async io enabled (disk_asynch_io=TRUE,filesystemio_options=SETALL): Elapsed times include waiting on following events:
11 user SQL statements in session.
This is with async io disabled (disk_asynch_io=FALSE,filesystemio_options=NONE):
Elapsed times include waiting on following events:
11 user SQL statements in session.
So, you see, turning off async io drastically improves performance in my situation (409 versus 716 seconds). I'm going to leave it off for now, and maybe create a service request on MOS to see if they can help. I couldn't find a lot on OTN.
Matthias Hoys
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| ||||||||||||||