11gr2 PARALLEL_DEGREE_POLICY is AUTO

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 9 Oct 2009 19:54:48 -0700 (PDT)
Message-ID: <909289.33955.qm_at_web23702.mail.ird.yahoo.com>



Hi

I am having trouble understanding what this parameter means. Just by its fancy title it says that

if PARALLEL_DEGREE_POLICY is AUTO then instead of writing

SELECT /* parallel (4 big_table) */
col1,col2 .........
from big_table

i can simply do this
SELECT
col1,col2 .........
from big_table

and oracle depending upon the size would decide what parallelism to use is my understanding correct       

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 09 2009 - 21:54:48 CDT

Original text of this message