Re: Configuring Oracle for an SMP machine

toadman wrote:
>
> Yes, it helps quite a bit. I just need to confirm now that
> Oracle is in fact utilizing all processors. It's a quad
> processor. One question though, exactly what does Oracle
> thread to different processors: distinct queries or distinct
> sessions?

Start svrmgr, connect as internal.
type 'show parameter cpu_count'.

As I remember, Oracle distribute Queries since V8; earlier versions need a separate option called 'distributed query option'; also, recovery is done parallel in every version since V7.

Elsewhere, _distinct_ queries are shared on all processors.

Sessions are distributed, since it is a OS-related job, I think ?

There's a comfiguration option called 'multi-threaded servers', used in environments with many simultanoes sessions, but is not available on NT.

bye, jm

-- 
SIG: In a world without fences, who needs gates.