Oracle教程 2023-03-27

Oracle 参数 THREADED_EXECUTION 官方解释，作用，如何配置最优化建议

本站中文解释

THREADED_EXECUTION参数主要用于控制多线程的启用和禁用，它是一个全局性参数。

如果THREADED_EXECUTION参数设置为TRUE，则表明允许基于线程的并行性的多线程特性被启用，即Oracle数据库允许多个用户线程在同一时间执行多个任务，这样可以提高数据库的速度。

如果THREADED_EXECUTION参数设置为FALSE，则表明禁用基于线程的全局性并行性，这样只有在Oracle数据库中的一个用户线程可以执行任务，另一个用户线程在某一时刻必须等待，才能执行新的任务。

正确设置THREADED_EXECUTION参数的方法如下:

1. 登录到数据库以sys用户身份
2. 运行SQL命令：ALTER SYSTEM SET THREADED_EXECUTION = TRUE;
3. 运行命令：scirpt reload;
4. 重新启动数据库。

官方英文解释

THREADED_EXECUTION specifies whether to enable the multithreaded Oracle model.

Property	Description
Parameter type	Boolean
Default value	On UNIX and Linux: `false` On Windows: `true`
Modifiable	No
Modifiable in a PDB	No
Range of values	`true \| false`
Basic	No
Oracle RAC	If specified, all instances must use the same value

THREADED_EXECUTION on UNIX and Linux

Oracle Database 12c introduced the THREADED_EXECUTION initialization parameter for databases running on UNIX and Linux systems. On such databases, the default value for THREADED_EXECUTION is false. Setting this parameter to true enables the multithreaded Oracle model, which allows Oracle processes on UNIX and Linux to run as operating system threads in separate address spaces.

By default, some background processes on UNIX and Linux always use threaded execution; the remaining Oracle processes run as operating system processes. Thus, an “Oracle process” is not always equivalent to an “operating system process.”

Note:

When THREADED_EXECUTION is set to true on databases running on UNIX and Linux systems, which enables the multithreaded Oracle model, operating system authentication is not supported. Attempts to connect to the database using operating system authentication (for example, CONNECT / AS SYSDBA or CONNECT / ) when this initialization parameter is set to true receive an ORA-01031 "insufficient privileges" error.

The solution to this error is to always use the password when connecting to the database.

Also, when this initialization parameter is set to true on databases running on UNIX and Linux systems, the DEDICATED_THROUGH_BROKER_listener-name=ON parameter should be added to the listener.ora file, where listener-name is the name of the Oracle Net listener and the LOCAL_LISTENER initialization parameter should be set to a TNS name entry corresponding to your instance service. This enables the server to spawn threads when connections to the database are requested through the listener.

THREADED_EXECUTION on Windows

Starting with Oracle Database 21c, the THREADED_EXECUTION initialization parameter is supported for databases running on Microsoft Windows. On such databases, this parameter must remain set to its default value of true; setting this parameter to false on databases running on Windows is not supported. The introduction of this parameter does not change the threading model for Oracle database on Windows. As in previous releases, an Oracle Database server instance on Windows is a service with a single multi-threaded operating system process. However, starting with Oracle Database 21c, you will observe changes to the V$PROCESS view, the dedicated connection broker, and the naming of trace files. For details about these changes, refer to Oracle
Database Administrator’s Reference for Microsoft
Windows.

Note:

Unlike on UNIX and Linux systems, when THREADED_EXECUTION is set to true on Windows, operating system authentication is supported.

本站中文解释

官方英文解释

相关推荐