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.