Further to Waleed' response: Field name called 'degree'. if > 1 then it invokes parallel process according to degree level defined.... if 2 will start 2 processes subject to maximum of parallel_max_servers defined in your init*.ora or in 8i depending on your other parallel settings..
Following param of 8i init ora are most relevent for parallel set up.. parallel_adaptive_multi_user TRUE parallel_automatic_tuning TRUE parallel_broadcast_enabled FALSE parallel_execution_message_siz 4096 parallel_instance_group parallel_max_servers 24 parallel_min_percent 0 parallel_min_servers 0 HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 12 Feb 2002 06:58:26 -0800 dba_tables -----Original Message----- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel? I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
