CPU utilization

O.S. => Windows NT
Oracle => 8.1.7.3.0

We have 8 CPU machine. But , oracle is only using 2 CPUs.
I have checked the init.ora parameter, cpu_count, which is set to 8.

Any suggestion?

Thanks.

Oracle does not control thread distribution across multiple CPUs, this is handled by NT.

If you want to use multiple CPUs, you have to implement parallel execution. Using parallel execution multiple processes work together simultaneously on a single statement over multiple CPU's.

See

http://download-west.oracle.com/docs...2paral.htm#365

for more info

Regards

Alter the degree of parallelism for your tables&indexes. This will invoke the PQ to be used when applicable:

ALTER TABLE table_name PARALLEL(DEGREE 8 INSTANCES 1)
/


Hope that helps,

clio_usa - OCP 8/8i/9i DBA

Visit our Web Site

Quote:

---

Originally posted by clio_usa

Visit our Web Site

---

Yeah, you get the same questions from (name omitted), a certified 8i/9i DBA, about "What is tkprof, an OS utility or is that from Oracle?"

Maybe this is the limit of your NT.
Is it NT enterprise edition? Try upgrade to win2K advanced server, which does support 8 CPU

I have 8 session are ruuning diff. sqls then why are they using only two CPUs?

Quote:

---

Originally posted by ora_inf
I have 8 session are ruuning diff. sqls then why are they using only two CPUs?

---

Because those two processors are not even close to being heavily loaded by those 8 sessions, I suppose. What is the CPU usage of those two processor when those 8 sessions are running? I guess not even close to 100% - am I right?

Only when those two processes will be under heavy load will the OS (not Oracle) unburden them by using other available processor(s). It is cheaper and more efficient in terms of resources that way.