Oracle-L: vxio:vol_maxio (Veritas) impact on Database perf ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 10 Feb 2003 01:23:37 -0800
Message-ID: <F001.005481F3.20030210012337@fatcity.com>

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 METALINK :-

Unix Installation/OS: RDBMS Technical Forum Displayed below are the messages of the selected thread. Thread Status: Closed

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

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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 10 2003 - 03:23:37 CST