Re: Oracle and multiple CPU's

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 Mon May 01 2000 - 00:00:00 CDT