Re: Performance of Oracle 7.3 Import on Windows NT (3.5 sp#5) 2 processors Vs 4 processors

From: Mark Rosenbaum <mjr_at_netcom.com>
Date: 1997/03/06
Message-ID: <mjrE6MyC2.6qp@netcom.com>#1/1

In article <331F5BEB.570B_at_escortnet.com>, Hurriyet Genc <hurriyet_at_escortnet.com> wrote:
>This is a multi-part message in MIME format.
>
>--------------1F9C78FB7506
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>I would appreciate ANY THEORIES why concurrent imports might perform
>slightly worse on a server with 4 processors than with 2 processors.
>
>Thanks in advance.
>Hurriyet Gendj
>(email: hxg_at_msg.ti.com or hurriyet_at_escortnet.com)
>

Running on 4 procs causes the disk to seek more and transfer less. This would mean that you have a hot spot on a disk.

Rather than theorize why not look at the system during the load process and see. Most SMP systems also allow you to offline processors in software so you could even run the test one after the other. You might also try 3 procs.

Hope this helps

Mark Rosenbaum			Otey-Rosenbaum & Frazier, Inc.
mjr_at_netcom.com			Consultants in High Performance and
(303) 727-7956			Scalable Computing and Applications
POB 1397			ftp://ftp.netcom.com/pub/mj/mjr/resume/

Boulder CO 80306 Received on Thu Mar 06 1997 - 00:00:00 CST