Name
THREAD
Synopsis
Value: 0-maximum number of enabled threads
Default: 0
Specifies the number of the redo thread that is to be used by the instance. THREAD is applicable only to instances that intend to run with Real Application Clusters or Parallel Server. Any available redo thread number can be used, but an instance cannot use the same thread number as another instance and cannot start when its redo thread is disabled. A value of 0 causes an available, enabled public thread to be chosen. Redo threads are specified with the THREAD option of the ALTER DATABASE ADD LOGFILE statement and enabled with the ALTER DATABASE ENABLE [PUBLIC] THREAD statement. The PUBLIC keyword signifies that the redo thread may be used by any instance. 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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
