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
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-lReceived on Fri Oct 09 2009 - 21:54:48 CDT