After completing this lesson, you should be able to do the following: Identify issues associated with managing users in an Oracle Shared Server environment Configure the Oracle Shared Server environment to optimize performance Diagnose and resolve performance issues with Oracle Shared Server processes | Tuning the Oracle Shared Server Objectives After completing this lesson, you should be able to do the following: Identify issues associated with managing users in an Oracle Shared Server environment Configure the Oracle Shared Server environment to optimize performance Diagnose and resolve performance issues with Oracle Shared Server processes Overview System Global Area Oracle background processes Dispatcher processes Database server Listener Client Shared server processes Oracle server code program interface Request queue Response queues Oracle Shared Server Oracle Shared Server is designed to allow multiple user sessions to share a server process. In a dedicated server environment, each user process is allocated a server process. This server process is often not fully used by the user process and has idle time and inactivity. However, the allocation of this server process consumes both memory and CPU resources, even when idle. When using the Oracle Shared Server, user processes are | Tuning the Oracle Shared Server Objectives After completing this lesson, you should be able to do the following: Identify issues associated with managing users in an Oracle Shared Server environment Configure the Oracle Shared Server environment to optimize performance Diagnose and resolve performance issues with Oracle Shared Server processes Overview System Global Area Oracle background processes Dispatcher processes Database server Listener Client Shared server processes Oracle server code program interface Request queue Response queues Oracle Shared Server Oracle Shared Server is designed to allow multiple user sessions to share a server process. In a dedicated server environment, each user process is allocated a server process. This server process is often not fully used by the user process and has idle time and inactivity. However, the allocation of this server process consumes both memory and CPU resources, even when idle. When using the Oracle Shared Server, user processes are dynamically allocated to a server process that can be shared across many user processes. The dispatcher process receives a request from a user process and places it in the request queue, so that a shared server can process it and return the results to the response queue for the dispatcher. The dispatcher process returns the results to the user after the results are placed in the response queue. A useful example is the reservations process for Oracle courses. A customer calls to inquire about a booking. The reservations clerk has a window in which to query course availability, but needs to talk to the customer for a few minutes first. The query is then sent to the database. After more conversation, the customer decides which course to book and the clerk commits the booking. In a ten-minute conversation, the dedicated server has been idle 99% of the time. Oracle Shared Server Characteristics Enables users to share processes Supports Oracle Net functionality Increases the number of .
