参考文档:
Real Application Clusters Administration and Deployment Guide
3 Administering Database Instances and Cluster Databases
Initialization Parameter Use in Oracle RAC
Table 3-3 Initialization Parameters Specific to Oracle RAC
THREAD | Specifies the number of the redo threads to be used by an instance. You can specify any available redo thread number if that thread number is enabled and is not used. If specified, this parameter must have unique values on all instances. The best practice is to use the |
Database Reference
1.350 THREAD
THREAD
has been superseded by the INSTANCE_NAME
and INSTANCE_NUMBER
parameters, and will be made obsolete in a future release of the Oracle Database.
Property | Description |
---|---|
Parameter type | Integer |
Default value |
|
Modifiable | No |
Modifiable in a PDB | No |
Range of values | 0 to the maximum number of enabled threads |
Basic | No |
Oracle RAC | If specified, multiple instances must have different values. |
很久之前,看到一个数据库,是主备模式, RAC架构。
奇怪的是,发现RAC节点1上的Thread不是默认的1,是默认的0,节点2上thread是1.
备库是单实例的,thread居然是0.
当时就比较好奇。咨询了下现场的工程师,说这样没什么问题,已经运行几年了。dg之间的切换也没有什么问题。当时很纳闷,thread怎么和默认的不一样。
今天看到官方的文档的时候,恍然大悟,原来可以设置成不一样。
END