Synopsis

Values:0 to maximum number of enabled threads

Default:0

Multiple Instances:Must have different values

Sets the number of the redo thread that is to be used by the instance. THREAD is applicable only to instances that intend to run in parallel (shared) mode. Though any available redo thread number can be used, an instance cannot use the same thread number as another instance and cannot start when its redo thread is disabled. A value of causes an available, enabled public thread to be chosen automatically.

Redo threads are specified with the THREAD option of the ALTER DATABASE ADD LOGFILE command and enabled with the ALTER DATABASE ENABLE [PUBLIC] THREAD command. The PUBLIC keyword signifies that the redo thread may be used by any instance, which is useful when running systems that have faster access to disks from certain nodes. Thread 1 is the default thread in exclusive mode, but an instance running in exclusive mode can specify THREAD to use the redo log files in a thread other than thread 1 if desired.