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!
OCP 8i, 9i DBA
Brisbane Australia