CPU utilization
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: CPU utilization

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    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.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Smile

    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

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    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?"

  5. #5
    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

  6. #6
    Join Date
    Jan 2001
    Posts
    230
    I have 8 session are ruuning diff. sqls then why are they using only two CPUs?

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  



Click Here to Expand Forum to Full Width