parallel hint
From: girlgeek <girlgeek_at_live.com>
Date: Wed, 03 Mar 2010 23:48:24 -0800
Message-ID: <BLU0-SMTP99EDFFAB13454AA171B83BBF390_at_phx.gbl>
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).
Date: Wed, 03 Mar 2010 23:48:24 -0800
Message-ID: <BLU0-SMTP99EDFFAB13454AA171B83BBF390_at_phx.gbl>
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-lReceived on Thu Mar 04 2010 - 01:48:24 CST