|Oracle® Database Reference
12c Release 1 (12.1)
|PDF · Mobi · ePub|
|Range of values||
|Oracle RAC||If specified, all instances must use the same value|
THREADED_EXECUTION specifies whether to enable the multithreaded Oracle model. Starting in Oracle Database 12c, the multithreaded Oracle model enables 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 this initialization parameter is set to
TRUE, 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 SYSDBAor
CONNECT /) when this initialization parameter is set to
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
=ON parameter should be added to the listener.ora file, where
listener-name is the name of the database listener. This enables the server to spawn threads when connections to the database are requested through the listener.
Oracle Database Concepts for more information about multithreaded Oracle
Table F-1, "Background Processes" for more information about background processes that run as threads instead of as operating system processes when multithreaded Oracle is enabled
Oracle Database Net Services Reference for more information about the
DEDICATED_THROUGH_BROKER_listener-name parameter in the listener.ora file