Unexpected Parallel Query Execution

Oracle 8.1.7.4.1 EE on W2K (SP3)

Is there anyway that parallel query slaves would be used for a query when every table in the dayabase has a degree of 1 and no parallel hints have been used in the SQL.

SQL> select distinct degree from dba_tables;

DEGREE

         1

SQL> sho parameter para

NAME                                 TYPE    VALUE


------------------------------------ -------

-------fast_start_parallel_rollback         string  LOW

optimizer_percent_parallel           integer 0
parallel_adaptive_multi_user         boolean FALSE
parallel_automatic_tuning            boolean FALSE
parallel_broadcast_enabled           boolean FALSE
parallel_execution_message_size      integer 2148
parallel_instance_group              string
parallel_max_servers                 integer 5
parallel_min_percent                 integer 0
parallel_min_servers                 integer 0
parallel_server                      boolean FALSE
parallel_server_instances            integer 1
parallel_threads_per_cpu             integer 2
recovery_parallelism                 integer 0

The following output from v$session shows that parallel query was being used which ended up consuming the total server CPU capcacity:

3472            SYSTEM              20   26544 ORACLE.EXE (P000)
3492            SYSTEM              12     440 ORACLE.EXE (P001)
3476            SYSTEM              24   17751 ORACLE.EXE (P002)
3420            SYSTEM              22   37652 ORACLE.EXE (P003)
2396            SYSTEM              26   15038 ORACLE.EXE (P004)
3452   SYSADM   COMMON\B89263       25   13709 SQLPLUSW.EXE

Matt Received on Thu Jul 29 2004 - 03:56:42 CDT