RE: Parallel execution question

o use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are is it okay If I set these paramet

Re: Parallel execution question

Raghu Run following query to check your parallel parameters set in initSID.ora. If your running paralell degree upto 5 default is ok. However parallel execution requires lot of overhead like memory usage and temp tablespace. Please refer some Manual/book for proper understanding as it is

Parallel execution question

Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are

Parallel execution question

Hi Friends, I want to use parallel execution to improve the performance of my Oracle7.3 database on AIX with front end baan. I read Oracle documentation, But they did't give me How to set these parameters.. PARALLEL_MIN_SERVERS PARALLEL_MAX_SERVERS PARALLEL_MIN_PERCENT My doubts are

Re: parallel execution

ltiple 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 > > -- > Please see the o

Re: parallel execution

parallel 2; > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -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 te

RE: parallel execution

Title: RE: parallel execution While on the topic, DEGREE VARCHAR2(10) The number of threads per instance for scanning the table What is a difference between '1' and 'DEFAULT'? SQL> select degree, count(*) from user_tables group by d

RE: parallel execution

tiple 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 lar

Re: parallel execution

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

parallel execution

Thanks to everyone who helped me with this problem! Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acces

Re: parallel execution

e which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)Received: from CONNECT-MTA by galotter

RE: parallel execution

How about DBA_TABLES where degree>1? Best, Sergey -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 execut

Re: parallel execution

, 2002 3:13 PM > 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 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com &g

RE: parallel execution

Mercadante Oracle Certified Professional -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

RE: parallel execution

tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

RE: parallel execution

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

RE: parallel execution

table have parallel execution turned on. Thanks is advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

parallel execution

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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat

PMON's use of parallel execution slaves

l see the trace of undo applied in the trace file of the parallel execution slave process used. So far as I am aware, this is not documented anywhere other than on the Ixora website. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Me