]
cc:
Subject:RE: Re: parallel index creation again:in which case, can we use p
If you only have one CPU, then is parallel either not supported, or simply a
waste of time?
I actually thought it was not supported. If you only have one CPU, what do
you expect to gain?
Tom Mercadante
PROTECTED]
cc:
Subject:RE: Re: parallel index creation again:in which case, can we
use p
If you only have one CPU, then is parallel either not supported, or simply a
waste of time?
I actually thought it was not supported. If you only have one CPU, what do
you
Steve,
I
believe what you say, but it seems counter-intuitive.
If you
only have one cpu, and you start two jobs, then it follows that the cpu needs to
split itself to do the work.
So,
what are we gaining? The CPU can only go so fast and do so much
work.
Tom Mercadante Oracle Certified
E: Re: parallel index creation
again:in which case, can we use p
Steve,
I
believe what you say, but it seems counter-intuitive.
If
you only have one cpu, and you start two jobs, then it follows that the cpu
needs to split itself to do the work.
So,
what are we gainin
:
Subject:Re: Re: parallel index creation again:in which case, can we
use p
Simply put, CPU is swifter than I/O (though not as much as some would have
us believe!).
7-8 years ago, we benchmarked Oracle 7.1 PQ on single-processor IBM RS6000
nodes and found that the sweet spot
:
Subject:RE: Re: parallel index creation again:in which case,
can we use p
If you only have one CPU, then is parallel either not supported, or simply a
waste of time?
I actually thought it was not supported. If you only have one CPU, what do
you expect to gain?
Tom Mercadante
Mercadante, Thomas F [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/12/2003 02:23 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: Re: parallel index creation again:in which case,
can we
: Re: parallel index creation again:in which case,
can we use p
If you only have one CPU, then is parallel either not supported, or simply a
waste of time?
I actually thought it was not supported. If you only have one CPU, what do
you expect to gain?
Tom Mercadante
Oracle Certified
My experience shows that a parallel degree of less than 4 is nearly always
slower than serial.
I would recommend tring parallel degree of 4.
-Original Message-
Sent: Wednesday, February 12, 2003 10:59 AM
To: Multiple recipients of list ORACLE-L
parallel with single cpu env?
Michael
If you only have one CPU, then is parallel either not supported, or simply a
waste of time?
I actually thought it was not supported. If you only have one CPU, what do
you expect to gain?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, February 12, 2003
Better utilization of the CPU. While one process is I/O-ing (or waiting on
an I/O) the other process can use the CPU.
Various tests I have performed on various unixes (unicies?) have shown the
parallelism usually scales to between 3 6 times the number of CPUs before
performance degrades.
Quite
11 matches
Mail list logo
