Re: Why does Oracle only use one CPU

Tom I wrote:
>
> We are running Oracle 8.1.6 on Compaq TRU64 UNIX 4.0D. Using the pmgr
> utility, the RDBMS is only showing activity on one CPU. Has anyone
> else seen this behavior?

This behaviour depends on what you are doing: If only _one_ session is performing ordinary SELECTs there is no need to employ any other processes.

But this will change as soon

- the SELECT is done in parallel
- the DML statements do INSERTs, UPDATEs, DELETEs
- other sessions start to work
- ...

Oracle scales very efficiently on SMP systems. On some high end Unix platforms it is possible to bind the Oracle instance to one CPU or CPU set, which - of course - decreases efficiency. I don't know True 64, but I guess this has such a feature, too.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!