Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Unexpected Parallel Query Execution

Re: Unexpected Parallel Query Execution

From: Matt <mccmx_at_hotmail.com>
Date: 30 Jul 2004 17:36:31 -0700
Message-ID: <cfee5bcf.0407301636.2ac2757c@posting.google.com> 





> I see only two possibilities:

> 1) DEGREE is set for some indexes

> 2) the statement ALTER SESSION FORCE PARALLEL {DML|DDL|QUERY} is used

> 




"Select distinct degree from dba_indexes" also returns 1.



No-one (except me) is aware of parallel capabilities so I would be
very surprised if anyone used this 'alter session force parallel'
command or a parallel hint.



I searched v$sqlarea while these parallel sessions were active and
none of them included a PARALLEL keyword.



Its a mystery...



Matt
Received on Fri Jul 30 2004 - 19:36:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US