9-Configuring Oracle Shared Server

9-Configuring Oracle Shared Server - Configuring Oracle...

Info iconThis preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
Configuring Oracle Shared Server Presenter Tathagata Bhattacharjee
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Configuring Oracle Shared Server Tathagata Bhattacharjee 2 Objectives After completing this lesson, you should be able to do the following ± Identify the components of the Oracle Shared Server ± Describe the Oracle Shared Server architecture ± Configure the Oracle Shared Server ± Identify and explain usefulness of related data dictionary views
Background image of page 2
Configuring Oracle Shared Server Tathagata Bhattacharjee 3 Server Configurations Dedicated server process Shared Server Process
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Configuring Oracle Shared Server Tathagata Bhattacharjee 4 Dedicated Server Process The user process and the server process are separate Each user process has its own server process The user and server process can run on different machines to take advantage of distributed processing There is one-to-one ratio between the user and the server process Even when the user process is not making a database request, the dedicated server process exists but remains idle
Background image of page 4
Configuring Oracle Shared Server Tathagata Bhattacharjee 5 Oracle Shared Server INSTANCE SGA Processes Snnn Snnn Snnn Dispatcher D001 Dispatcher D002 Dispatcher D003 Database Server Client User Process User Process
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Configuring Oracle Shared Server Tathagata Bhattacharjee 6 The Oracle Shared Server configuration enables shared servers, dedicated servers and combined users and servers to exist within the same instance
Background image of page 6
Configuring Oracle Shared Server Tathagata Bhattacharjee 7 In an online transaction processing environment for example, order entry applications, in which users enter data through an application interface, the server process could be idle 90% or more of the connected time
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Configuring Oracle Shared Server Tathagata Bhattacharjee 8 Oracle Shared Server improves server efficiency, because any server process can process an incoming request, rather than wait for a specific server to process work on a request With Oracle Shared Server, you can support many more users than you can in the dedicated mode with the same number or server processes, because users in the Oracle Shared Server architecture share the server processes and thus fewer server processes can be configured
Background image of page 8
Configuring Oracle Shared Server Tathagata Bhattacharjee 9 Under the Oracle Shared Server architecture, client-user processes ultimately connect to a dispatcher . The PMON process registers the location and load of dispatchers with the listener, enabling the listener to forward requests to the least utilized dispatcher
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Configuring Oracle Shared Server Tathagata Bhattacharjee 10 A dispatcher can support multiple client connections concurrently Each client connection is bound to a virtual circuit A virtual circuit is a piece of shared memory used by the dispatcher for client database connection requests and replies
Background image of page 10
Configuring Oracle Shared Server Tathagata Bhattacharjee 11 The dispatcher places a virtual circuit on a common queue when a request arrives A shared server picks up the virtual circuit from
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 41

9-Configuring Oracle Shared Server - Configuring Oracle...

This preview shows document pages 1 - 12. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online