Howdy!... Hey, I'm doing some testing on Parallel Queries and received some interesting results. As anyone got any advice for me.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> set timi on
SQL> select count(*) from crp_sio;

COUNT(*)
----------
658768

Elapsed: 00:00:01.26

SQL> alter session force parallel query;

Session altered.

Elapsed: 00:00:00.00

SQL> select count(*) from crp_sio;

COUNT(*)
----------
658768

Elapsed: 00:00:05.91

I mean a parallel count(*) took 5 seconds over a normal unparallel query of 1 seconds... it this a normal thing.

Thanks party people!