InterviewSolution
| 1. |
What Is Multi Threaded Server (mta) ? |
|
Answer» 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. 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. |
|