Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

aioservers for Oracle 1

Status
Not open for further replies.

mdraja

Programmer
Oct 14, 2003
44
0
0
GB
Hi

Does anyone have any experience of aio server settings for an AIX server using Oracle? Can one set these very high - say 500? If so, will this completely thrash the CPU continuosly?
 
AIO servers cost more memory than CPU as I recall, so you'll want to keep that in mind.

I believe Oracle's suggestion for the AIO server count is a minimum of 5 and a maximum of 10 per physical disk (hdisk in AIX parlance).

So for example, using a full 7133 array as an example:
If the array is being used as JBOD, you have 16 usable disks, and you'd have 80 to 160 AIO servers.

If the array is set up to be mirrored by the SSA card, or RAID5ed, you only see 1 hdisk, and therefore 5 to 10 AIO servers.
 
If you have enough memory (which you should have, in order to unleash all the available power in the processors ;-)) you can increase the number of aioservers to 100 per CPU or more. You have to increase maxreqs also because it doesn't help having free aioservers, if there's no free AIO request buffer space...

If you do a
pstat -a|grep aioserver (could be pstat -A - don't remember exactly)
and notice that they are all consuming CPU seconds, then you don't have enough of 'em. If you have some which are at 0:00 CPU seconds, then you're fine. If you have a lot at 0:00 then you can go down.

The trouble with not having enough aioservers is, when they are all busy and the application needs to do an async IO, the application will go into WAIT until an aioserver gets freed. So instead of having an aioserver doing all the waiting for IO, your application also gets delayed.

The trouble with having too many aioservers is that you are eating away at memory that may have other more efficient use.

Limiting the number of aioservers on dev or test machines is also a way of limiting the load on your SAN server(s) by those dev/test machines.


HTH,

p5wizard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top