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 ???
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.
Hi, 9th May 2001 20:33 hrs chennai
The first link will help you on this
Did you balance the number of latches with the number of CPU's==>just to know what how you have balanced this.
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width