From: VIVEK_SHARMA (VIVEK_SHARMA@infosys.com)
Date: Tue Feb 11 2003 - 00:51:32 EST
Setting of parameter vxio:vol_maxio (Veritas)
Nature of Database Hybrid in Nature
Application Database undergoing MOSTLY Index Scan Operations (db file
sequential reads).
The underlying OS Call is pread64 .
Qs. Anybody has used the parameter in Production Databases ?
Qs. Is there any known Overhead/down-side with using the parameter ?
Qs. What is the impact on Database performance ?
Qs. What Value may be considered Advisable ?
Qs. How may the same be Calculated
A SAMPLE ARTICLE FROM ORACLE METALINK :-
*****************************************************************************
*************
Unix Installation/OS: RDBMS Technical Forum
Displayed below are the messages of the selected thread.
Thread Status: Closed
From: syed hussain 01-Oct-01 20:26
Subject: vxio: vol_maxio
RDBMS Version: 8.1.6.2
Operating System and Version: solaris 2.6
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:
vxio: vol_maxio
What is the recommended setting for vol_maxio (when I am using VxVm and VxFs )
?
When I set to vol_maxio=65535 (which means 32 MB ) the querries runs very fast
. but is it desirable to set it that high ?
How do I determine the most desirable value ?
what other impacts it might have ?
thanks
syed
-----------------------------------------------------------------------------
--- From: Riyaj Shamsudeen 02-Oct-01 22:19 Subject: Re : vxio: vol_maxio It depends. vol_maxio determines the maximum size of the physical IO that veritas layer can handle before breaking up the IO in to multiple IO requests. If your application uses mostly sequential read, then the application will benefit from using bigger vol_maxio value. But having a value of 32MB may not provide any benefits. maxphys kernel parameter need to be increased to take advantage of the bigger IO size request too. Further, Oracle has a limit of 1MB for the max IO size that oracle can issue(at least in 8i releases). So, any value beyond 1MB may not provide any benefit. You also need to look at your disk subsystem. If you have striped disks, then it is better to match vol_maxio value and the stripe width. Say, if the stripe size is 128KB with 4 disks (hence the stripe width 512KB) then you want to set your vol_maxio to match 512KB, but not exceeding 1MB. _______________________________________________ sunmanagers mailing list sunmanagers@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:25:47 EDT