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

Home -> Community -> Mailing Lists -> Oracle-L -> How to stop using parallel slaves? -More Info

How to stop using parallel slaves? -More Info

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Mon, 10 Oct 2005 23:08:39 -0400
Message-ID: <f09dd6280510102008sae195d0v9c172d790d4acca7@mail.gmail.com>


Sorry I forgot to mention the environment

Environment:
9.2.0.6 <http://9.2.0.6> - 3 Node RAC,Sun OS 2.9, 8 CPU (each Node)

I don't know how optimizer decides to use PARALLEL SLAVES to run such a small query.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 10 2005 - 22:10:53 CDT

Original text of this message

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