首页 > 数字化转型 > ERP > Initianization Parameter (5) : THREAD

Initianization Parameter (5) : THREAD

原创 ERP 作者:tsinglee 时间:2007-10-29 09:28:16 0 删除 编辑

Parameter type : Integer
Default value : 0
Modifiable : No
Range of values : 0 to the maximum number of enabled threads
Real Application Clusters : If specified, multiple instances must have different values.

THREAD is a Real Application Clusters parameter that specifies the number of the redo
thread to be used by an instance.

When you create a database, Oracle creates and enables thread 1 as a public thread
(one that can be used by any instance). You must create and enable subsequent threads
using the ADD LOGFILE THREAD clause and ENABLE THREAD clause of the ALTER
DATABASE statement. The number of threads you create is limited by the
MAXINSTANCES parameter specified in the CREATE DATABASE statement.

In exclusive mode, thread 1 is the default thread. However, you can specify THREAD
for an instance running in exclusive mode if you want to use the redo log files in a
thread other than thread 1.

In parallel mode, you can specify any available redo thread number, as long as that
thread number is enabled and is not in use by another instance.

A value of zero specifies that this instance can use any available, enabled public


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: 国内大学校训
请登录后发表评论 登录
  • 博文量
  • 访问量