Re: one transaction use one cpu?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Dec 2000 06:29:25 +0100
Message-ID: <91b7e5$3jf4g$1@ID-62141.news.dfncis.de>

Not parallel server, but parallel query, available in the Enterprise Edition only.
The only other thing you could do is pbind the background processes to different cpus.

Hth,

Sybrand Bakker, Oracle DBA

<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 Wed Dec 13 2000 - 23:29:25 CST