tuning DB on 4 cpu processor
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tuning DB on 4 cpu processor

  1. #1
    Join Date
    Aug 2000
    Location
    NJ
    Posts
    54

    Angry

    Hi,

    I have a 4 CPU AIX box with oracle 8.1.7 (64 bit).
    I observed that on running sar command, Oracle is using only 1 cpu at any instance of time (oracle proceeses are not bound to any CPU).
    The degree of parallelism is one on e tables and indexes.

    Waht it the alter table or alter index command to alter the degree. Can I alter and reset it to 1 later on ???

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Degree of parallelism can be implemented at the instance level (in init.ora), table level or query level. You can use the command:alter table table_name degree=2 (don't quite remember the exact syntax, give it a try). Yes, it can be changed back.

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Link

    Hi, 9th May 2001 20:33 hrs chennai

    The first link will help you on this

    http://www.oradoc.com/ora816/paraser...0/psadm_px.htm

    http://www.dbmsmag.com/9705d16.html

    http://info-it.umsystem.edu/oradocs/...conce.htm#1051

    Did you balance the number of latches with the number of CPU's==>just to know what how you have balanced this.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

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