1Z0-060 · Question #168
Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?
The correct answer is A. The local listener may pass the request to an existing process which in turn will create a thread. D. Thread creation must be routed through a dispatcher process. In Oracle 12c multithreaded mode on UNIX, the listener hands off connections to existing processes that then spawn threads, and all new thread creation is coordinated through a dispatcher process.
Question
Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?
Options
- AThe local listener may pass the request to an existing process which in turn will create a thread.
- BEach multithreaded Oracle process has an SCMN thread.
- CEach Oracle process runs an SCMN thread.
- DThread creation must be routed through a dispatcher process.
How the community answered
(28 responses)- A43% (12)
- B36% (10)
- C21% (6)
Why each option
In Oracle 12c multithreaded mode on UNIX, the listener hands off connections to existing processes that then spawn threads, and all new thread creation is coordinated through a dispatcher process.
In Oracle 12c multithreaded architecture, the local listener passes an incoming connection request to an already-running Oracle process, which then creates a new OS-level thread to service that connection rather than forking an entirely new dedicated server process as in traditional mode.
Not every multithreaded Oracle process contains an SCMN thread; SCMN is a specialized thread type tied to specific process roles and is not a universal component present in all Oracle processes.
SCMN threads are not present in every Oracle process; they are specific to certain process types in the multithreaded model and are not a mandatory thread component of each process.
In multithreaded mode, thread creation for new connections must be routed through a dispatcher process, which manages thread lifecycle and distributes incoming connection workload among available threads within the shared process model.
Concept tested: Oracle 12c multithreaded architecture connection handling on UNIX
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/process-architecture.html
Topics
Community Discussion
No community discussion yet for this question.