System I/O and Disk I/O

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 - 12:02:15 CST