Re: How to increase the number of threads.

you'd need to be running Oracle Parallel Server.

the clause "thread 2" in the context you are using it refers to multiple Oracle instances managing a single database, each instance writes its own log files.

if you can't make sense of that, then you may find it beneficial to review the Oracle Concepts manual, available free of charge with registration at OTN. http://technet.oracle.com

i think i'd be more concerned with the number of log groups, and adding a second member to each log group, rather than trying to add a thread.

"Student" <kennylim_at_techie.com> wrote in message news:9hj8a7$brp$1_at_slb1.atl.mindspring.net...
>
> 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 ?
>
> Any advise will be greatly appreciated. Thanks.
>
> Student-
>
>
>
>
Received on Sun Jul 22 2001 - 01:54:31 CDT