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