Re: System I/O and Disk I/O

penghd wrote:

> 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.

There is not enough information here to be of much help to you. Have you run explain plan on both systems and compared the results?

If not ... that is the first step.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)