parallel query works on single CPU or not?

Hi,

We run Oracle Work Group Server 7.3 on NT4.0. The default in init.ora file sets 5 max parallel server. I altered a large table (not index) with parallel degree 3 but did not see the performance gain. So, my questions are:

  Does parallel query work on single CPU ?   How can you tell if a parallel query is being performed?   Is there any other parameters need to be tuned?

Thanks,

Leslie    Received on Fri May 09 1997 - 00:00:00 CDT