Re: parallel query

From: <sjaffarhussain_at_gmail.com>
Date: 2 May 2005 23:27:59 -0700
Message-ID: <1115101679.528486.278710@g14g2000cwa.googlegroups.com>

When PARALLEL_AUTOMATIC_TUNING is set to true, Oracle determines the default values for parameters that control parallel execution. In addition to setting this parameter, you must specify the PARALLEL clause for the target tables in the system. Oracle then tunes all subsequent parallel operations automatically.

When your table having noparallel, all the queries run in noparallel mode only, again this table, though you use parallel hint. Received on Tue May 03 2005 - 01:27:59 CDT