1Z0-062 · Question #83
Which three 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. Thread creation must be routed through a dispatcher process D. Each multithreaded Oracle process has an SCMN thread. E. The local listener may pass the request to an existing process which in turn will create a thread. In Oracle 12c multithreaded architecture on UNIX, the listener routes connection requests to existing processes that then create threads, new thread creation goes through a dispatcher, and each multithreaded process contains an SCMN thread.
Question
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?
Options
- AThread creation must be routed through a dispatcher process
- BThe local listener may spawn a now process and have that new process create a thread
- CEach Oracle process runs an SCMN thread.
- DEach multithreaded Oracle process has an SCMN thread.
- EThe local listener may pass the request to an existing process which in turn will create a thread.
How the community answered
(39 responses)- A82% (32)
- B5% (2)
- C13% (5)
Why each option
In Oracle 12c multithreaded architecture on UNIX, the listener routes connection requests to existing processes that then create threads, new thread creation goes through a dispatcher, and each multithreaded process contains an SCMN thread.
In multithreaded architecture, thread creation is not handled directly by the listener; instead, all new thread creation is routed through a dispatcher process that manages thread lifecycle within multithreaded Oracle processes.
In multithreaded architecture, the listener does not spawn new processes to create threads; it routes requests to existing processes or through dispatchers - spawning a new process per connection is the dedicated server model, not multithreaded.
Not every Oracle process contains an SCMN thread; the SCMN thread exists only within multithreaded Oracle processes, making option C an overly broad and incorrect generalization of option D.
Each Oracle process operating in multithreaded mode contains a dedicated Service Control Manager Network (SCMN) thread, which handles service registration with the listener and manages inbound connection handoffs for that process.
The local listener can hand off a new connection request to an already-running multithreaded Oracle process, which then internally spawns a new thread to service that connection, avoiding the overhead of creating a new OS process.
Concept tested: Oracle 12c multithreaded server architecture and listener connection handling
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cncpt/process-architecture.html#GUID-310F28E4-8C5B-4D5D-9E25-4E7F60C28858
Topics
Community Discussion
No community discussion yet for this question.