tuning DB on 4 cpu processor

[geobg]

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

[Halo]

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.

[padmam]

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