Re: Oracle and multiple CPU's

We are using Digital UX 4.0D and we have two CPUs.

What I find is that each Oracle session can only use one CPU at a time, even if it is doing a data load or something similar.

We are using Oracle 7.3.4, however, maybe Oracle 8.0 and 8.1 are different. (?)

When two big jobs are running, the two sessions hover at around 99.9% CPU utilization each, to drop only when more people submit tasks to the server. If four people are submitting big jobs at the same time, then they each get about 49% CPU, one user session utilizing only one CPU at a time.

When I parallelize the tables, however, one user session can use both CPUs and the total time drops accordingly. Note this is Oracle7.3, so only parallel selects can be done. On Oracle8 you can do parallel DML, and I believe that in 8.1 you can do parallelized object creation (?).

Regards,

Pat.

Sybrand Bakker wrote:

> Not necessarily. Distribution of workload will be done by the O/S. Most SMP
> enabled O/Ses will use all available processors.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> <kal121_at_my-deja.com> schreef in berichtnieuws 8ekj0m$mv3$1_at_nnrp1.deja.com...
> > How does Oracle utilize multiple CPU's if you're not using PQO
> > (Parallel Query Option)? I've seen PQO using multiple processors, and
> > it sure does it speed things up during full table scans.
> >
> > But what if you're not running any full table scans - therefore you
> > aren't using PQO - I guess Oracle can only use one CPU at a time in
> > that case. Right?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Tue May 02 2000 - 00:00:00 CDT