Yes, but what was the question?
"Fink, Dan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
12/16/2002 10:00 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: Parallel degree on tables and indexes
Ah, yes...the magic number. For all questions requiring a magic number,
that
number is 42. ;)
-----Original Message-----
Sent: Monday, December 16, 2002 8:39 AM
To: Multiple recipients of list ORACLE-L
List,
Is there a 'magic' number for num_rows that you use in order to set the
parallel degree on tables and/or indexes?
We were told to use parallel degree of 4 for tables having more than
100,000
rows. Some of the on-line queries are running in parallel mode thus making
batch jobs to go serial for lack of parallel slaves.
Upon a closer look, we see tables/indexes having millions of rows having
parallel degree set at 1 and tables/indexes having fewer than 100,000 rows
are having parallel degree set at 4 etc.,
Is there a number for num_rows that you have been very successful to
determine the parallel degree? Some of the indexes were re-built using
parallel degree of 3 to reduce the 'create index' time but were not
changed
back to 'noparallel' recently and I need to answer these questions.
TIA.
Govind
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Fink, Dan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
