Call to arms:


I: What is the better choice on x86_64,RHEL4u4(2.6x kernel), EMC
CX300 SAN, EMC powerpath 4.5x, Oracle 10.2.0.3.0, RAC, ASM?

1) ASMlib accessing block dev, asynch i/o
2) Raw device access via /dev/raw/rawX

II: Which i/o scheduler do you use with each respective technology
stack?

1) CFQ
2) Deadline
3) No-OP
4) Anticipator

III: Last question: Which parameter do you use for the above?

1) DISK_ASYNCH_IO
2) FILESYSTEMIO_OPTIONS

On May 11, 7:19 am, oracle_man <oracle_... (AT) yahoo (DOT) com> wrote:
On http://www.oracle.com/technology/tec...ons/index.html
you can find useful informations
i) Oracle recommends use of ASMlib for easy of management. In my
opinion is not a great advantage, but on Kernel 2.6 Raw are
deprecated,
(however if you use RAC whitout cluster filesystem you must use raw
devices for ocr and voting).
ii) On validated configurations oracle suggest use of Deadline
schedulator
iii) i use default values for DISK_ASYNCH_IO (that is true on my suse
el9 installations) and FILESYSTEMIO_OPTIONS that is not relevent if
you use ASM.

Bye
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com

oracle_man wrote:
ASM by almost any definition if your requirements include
maintainability.

But either way look up UDEV and device persistence.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On 10 May 2007 22:19:14 -0700, oracle_man <oracle_man (AT) yahoo (DOT) com>
wrote:

upgrade SAN if IO is important.

CX500 is a much better option.. We've had good results with vxfs +
odm, but other file systems can be a good option too.

the 3 CX300's we have are all dogs, 45megs/sec across 10disk RAID5,
and only 111 or so across a 20 disk metalun (2x10disk RAID 10s)
The CX500 has 'near-line' performance with 16disk raid 10's

Oh yeah EMC.. and your support BLOWS! My next array will be Hitachi!
BTW, has had good results with local SAS drives, hoping the dell
MD3000 we just got will blow away any low-to-midrage EMC (6disk RAID10
was going at 150megs sec)

There are all sequential writes, btw.
........
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
remove NSPAM to email