Very Computer

by **susan..** » Fri, 15 Dec 2000 14:03:49

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/

by **Ivan Bajo** » Fri, 15 Dec 2000 18:15:54

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

hth,
Ivan Bajon, ocp

> 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/

by **Sybrand Bakke** » Fri, 15 Dec 2000 14:29:25

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

> 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/

Very Computer

one transaction use one cpu?

one transaction use one cpu?

one transaction use one cpu?

one transaction use one cpu?