-
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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
-
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
www.cnoug.org
-
I have 8 session are ruuning diff. sqls then why are they using only two CPUs?
-
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.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|