parallel hint

From: girlgeek <>
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,

Received on Thu Mar 04 2010 - 01:48:24 CST

Original text of this message