RE: parallel hint
Date: Thu, 4 Mar 2010 05:58:38 -0600
Message-ID: <C970F08BBE1E164AA8063E01502A71CF016E9E2D_at_WIN02.hotsos.com>
It uses the default degree of parallelism from the table. So if it's not set at the table, you'll get a serial plan.
Ric Van Dyke
Hotsos Enterprises, Ltd.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of girlgeek
Sent: Thursday, March 04, 2010 2:48 AM
Cc: oracle-l
Subject: parallel hint
I see from the documentation that it is perfectly valid to write a
parallel hint with neither degree nor default.
For example:
select /* + parallel */ ename from emp;
(please pretend that emp is not a tiny table).
What will oracle use to calculate the degree of parallelism used when the hint is constructed as above?
I have been unable to find the answer in the documentation.
Thank you,
Claudia
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 04 2010 - 05:58:38 CST