Re: How to increase the number of threads.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sun, 22 Jul 2001 06:54:29 GMT
Message-ID: <9hj9up0rqj_at_drn.newsguy.com>


In article <9hj8a7$brp$1_at_slb1.atl.mindspring.net>, "Student" says...
>
>
>Good Evening,
>
>I am wondering if anyone knows how to increase the number of threads
>available in a parallel database ? When I created the database, I seem to
>have
>only 1 thread.
>
>alter database add logfile thread 2 group 21 '/dev/raw8' size 10M;
>alter database add logfile thread 2 group 22 '/dev/raw9' size 10M;
>
>SQL> alter database add logfile thread 2 group 2 1 '/dev/raw8' size 10M
>*
>ERROR at line 1:
>ORA-01611: thread number 2 is invalid - must be between 1 and 1
><=====How Can I increase to 4 ?
>

those are redo threads, there is only one thread of redo per instance.

How is it that you are adding the same raw device twice to the database?

redo threads and parallel operations have nothing to do with eachother.

see
http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/c22paral.htm#365

to get information on parallel query if that is what you are after.

You might want to give the entire:

http://technet.oracle.com/doc/oracle8i_816/server.816/a76965/toc.htm

Oracle8i server concepts manual a read through

>Any advise will be greatly appreciated. Thanks.
>
>Student-
>
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Sun Jul 22 2001 - 08:54:29 CEST

Original text of this message