Re: aix 5.2, oracle 9.2 and mount with CIO option

From: Bill Verzal (BVerzal@KOMATSUNA.COM)
Date: Wed Sep 03 2003 - 11:43:28 EDT


What is your LVM readahead set to ?

ioo -o maxpgahead -o j2_maxPageReadAhead

BV
--------------------------------------------------------

Bill Verzal
AIX Administrator, Komatsu America
(847) 970-3726 - direct
(847) 970-4184 - fax

|---------+-------------------------------->
| | "Hunter, Mark" |
| | <Mark.Hunter@ANHEUSER|
| | -BUSCH.COM> |
| | Sent by: IBM AIX |
| | Discussion List |
| | <aix-l@Princeton.EDU>|
| | |
| | |
| | 09/03/2003 10:23 AM |
| | Please respond to IBM|
| | AIX Discussion List |
| | |
|---------+-------------------------------->
>-------------------------------------------------------------------------------------------------------------------------------|
  | |
  | To: aix-l@Princeton.EDU |
  | cc: |
  | Subject: aix 5.2, oracle 9.2 and mount with CIO option |
>-------------------------------------------------------------------------------------------------------------------------------|

Any one have any experience with concurrent access mounted directory for
Oracle
databases?
AIX 5.2 with Maint level 1.

4 way striped logical volumes with 64K stripe size.

A simple dd if=/dev/zero of=filename bs=4096 runs incredibly slow. IBM's
whitepaper on this indicates I should see very good performance.

The actual database runs about 30% slower than with normal, cached I/O.

Mark Hunter
Anheuser-Busch Cos.
MIS Consultant, Computer Services
*Office: (314) 632-6663
*Fax: (314) 632-6901
*Pager: (314) 841-4026
*Email: Mark.Hunter@Anheuser-Busch.com



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:17:10 EDT