Process Architecture (contd)
- two task architecture. Each user session has a task.
- to protect SGA from possible corruption, user task passes request to server process, which connects to SGA and carries out user request. A server process for each user, which contains Oracle’s trusted code.
- Multi-threaded server is another option. It is used in very large OLTP systems with thousands of connected users. Requests are processed by a pool of shared servers. These are good when each user uses for a small % of time. MTS is not appropriate in data warehousing as there are limited users with heavy load.