DEVFYI - Developer Resource - FYI

What is Multi Threaded Server (MTA) ?

ORACLE Interview Questions and Answers (Part 5)


(Continued from previous question...)

57.What is Multi Threaded Server (MTA) ?

In a Single Threaded Architecture (or a dedicated server configuration) the database manager creates a separate process for each database user. But in MTA the database manager can assign multiple users (multiple user processes) to a single dispatcher (server process), a controlling process that queues request for work thus reducing the databases memory requirement and resources.

(Continued on next question...)

Other Interview Questions