Snnn—the Shared Server process

When utilizing the Multi-Threaded Server (MTS) configuration of Oracle, one or more Shared Server processes are created with names S001, S002, and so on. These processes allow many user processes (discussed later in this chapter) to create connections to the Oracle instance, thereby reducing the system overhead while increasing the number of users that can be supported. When running without Multi-Threaded Server, and thus without any Snnn processes, each user connection to the database requires a dedicated server connection to the instance, which can quickly consume available resources (especially memory) and limit the number of user connections possible. The initial number of Shared Server processes created is controlled by the MTS_SERVERS parameter in INIT.ORA, and the total number is limited by the parameter MTS_MAX_SERVERS. Note that due to the nature of Shared Server processes, user-related data is not contained in the Program Global Area (PGA). Instead, this data is stored in the System Global Area (SGA).

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset