RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration

2002-07-15 Thread VIVEK_SHARMA
maxservers Already to a High Value i.e. 400 as can be seen below . %wio nevertheless Continues to be about 40-45% After applying the patch 8.1.7.4 , I shall Let you folks know about the %wio Figure NOTE - cpu_count = 18 Async_io: lsattr -E -l aio0 minservers 10

RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration

2002-07-11 Thread VIVEK_SHARMA
We are Considering Upgrading from 8.1.7.2 to 8.1.7.4 on AIX 4.3.3 Any Do's,Cares to be Taken ? Any Advice / Serious Bugs known on this Patch Version ? Thanks -Original Message- Sent: Wednesday, July 10, 2002 8:49 PM To: LazyDBA.com Discussion After migration from Oracle ver 7.3.4 to

RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration

2002-07-11 Thread Adrian Roe
The fsync() blocks the process until all the dirty pages are written to the physical disks - maybe this is a problem with async i/o ? How many async i/o servers are configured on the AIX box (use smitty aio to check). As a start point set to the maximum to Number of CPU's * 10 and set the min

Re: High %wio on AIX O.S. DB Server after Oracle 8i Migration

2002-07-10 Thread Jared . Still
1) use raw disk 2) use Veritas Quick IO Jared VIVEK_SHARMA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/10/2002 09:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:High %wio on AIX O.S. DB