Re: one transaction use one cpu?

From: Ivan Bajon <bajon_at_nospam@worldonline.dk>
Date: Thu, 14 Dec 2000 10:15:54 +0100
Message-ID: <91a30t$qas$1@news.inet.tele.dk>

No, you might benefit from using "Parallel Query" which will put more CPUs to work on a single query.

hth,
Ivan Bajon, ocp

<susana73_at_hotmail.com> wrote in message news:919kbi$da$1_at_nnrp1.deja.com...
> Hi,
>
> I have a 4-cpus Sun Solaris 2.6. I noticed that one database
> connection/transaction only uses 1 of the 4 cpus. If I only have 1
> transaction, the other 3 cpu will be idled. Is Oracle supposed to be
> work like this? Is "parallel server" the only option to make a
> transaction uses multiple cpu at the same time?
>
> Thanks in advance.
> Susan
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 14 2000 - 03:15:54 CST