Re: System I/O and Disk I/O

Hello penghd,

  As one of the posters mentioned you need to find out if you really I/O bound or not.

  Statspack report would help to identify on what database is waiting for. You can use individual UNIX utilities (sar, vmstat,top etc) or smitty "Resource Status & Monitors" to correspond database and OS performance information.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"penghd" <penghd_at_hotmail.com> wrote in message news:579318c1.0403061002.7b789d2c_at_posting.google.com...
> Hi there.
>
> We have a C/S OLTP system running on oracle9i.
> When we put the oracle server on a windows 2000 Server, system works
> well. From the windows monitor tool, it show the whole system I/O is
> 8MB/s, but the harddisk R/W rate only about 500KB/s.
> But when we migrate the oracle server to an IBM pserie Server(AIX OS),
> it ran slow as hell. Because we are using Disk array, we cant get the
> real R/W rate of real harddisk, but just the I/O of the Logical
> Volume, its about 8MB/s too.
>
> So I think its some problem about the CACHE (database cache or system
> cache), is it?
>
> The PC Server and AIX Server both have 2CPU 2G MEM, and the database
> init.ora are same. Is there something need pay attention on UNIX?
>
> And should we try the Multi-Thread Server Mode? There are about 200
> client. So on the AIX Server we can see 200+ Oracle Processess.
>
> Thx, and sorry about my poor English.
Received on Sat Mar 06 2004 - 18:28:00 CST