1 / 23

Oracle Shared Servers

Oracle Shared Servers. Objectives. After completing this lesson you should be able to do the following: Identify when to use Oracle Shared Servers Configure Oracle Shared Servers Monitor Shared Servers. Establishing a Connection. Incoming connection request. Listener.

lars
Download Presentation

Oracle Shared Servers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Shared Servers

  2. Objectives • After completing this lesson you should be able to do the following: • Identify when to use Oracle Shared Servers • Configure Oracle Shared Servers • Monitor Shared Servers

  3. Establishing a Connection Incoming connection request Listener

  4. Dedicated Server Process Server process User process Listener

  5. User Sessions Server process User Session PGA User process Listener

  6. User Sessions: Dedicated Server User sessions Server process Server process User session Server process

  7. User Sessions: Shared Server Server process Dispatcher Listener

  8. Userprocess Processing a Request Shared serverprocesses Instance 4 SGA S000 Response queue for D000 Common request queue for all dispatchers S001 Response queue for D001 3 S002 Response queue for D002 2 5 DispatcherD000 DispatcherD001 DispatcherD002 6 Database server 1 Userprocess Client or middle tier

  9. The SGA and PGA Dedicated server: User session data is kept in the PGA. • SGA • PGA User session data Stack space Cursor state • Shared pool and other memory structures • Oracle Shared Server: User session data is held in the SGA. • SGA • PGA User session data Cursor state Stack space • Shared pool and other memory structures

  10. Configuring Oracle Shared Server • Required parameter • DISPATCHERS • Optional parameters • SHARED_SERVERS • MAX_SHARED_SERVERS • CIRCUITS • SHARED_SERVER_SESSIONS

  11. DISPATCHERS = “(PROTOCOL=TCP)(DISPATCHERS=2)\ (PROTOCOL=IPC)(DISPATCHERS=1)” DispatcherD000 TCP/IP DispatcherD001 TCP/IP DispatcherD002 IPC DISPATCHERS • Specifies the number of dispatchers that are initially started for a given protocol.

  12. S000 S002 S004 S001 S003 S005 SHARED_SERVERS • Specifies the number of shared server processes created when an instance is started up, and retained during instance operation. SHARED_SERVERS = 6

  13. S006 S000 S002 S004 S008 S007 S001 S003 S005 S009 MAX_SHARED_SERVERS • Specifies the maximum number of shared servers that can be started • Allows shared servers to be allocated dynamically based on the length of the request queue MAX_SHARED_SERVERS = 10

  14. CIRCUITS • Specifies the total number of virtual circuits that are available for inbound and outbound network sessions • Contributes to total SGA size CIRCUITS = 100

  15. SHARED_SERVER_SESSIONS • Specifies the total number of Oracle Shared Server user sessions to allow • Enables you to reserve user sessions for dedicated servers SHARED_SERVER_SESSIONS = 100

  16. Related Parameters • Other initialization parameters affected by Oracle Shared Server that may require adjustment: • LARGE_POOL_SIZE • SESSIONS • PROCESSES • LOCAL_LISTENER

  17. Verifying Shared Server Setup • Verify that the dispatcher has registered with the listener when the database was started by issuing: • Verify that you are connected using shared servers by making a connection and then query V$CIRCUIT view to show one entry per shared server connection. $ lsnrctl SERVICES

  18. Data Dictionary Views • V$CIRCUIT • V$SHARED_SERVER • V$DISPATCHER • V$SHARED_SERVER_MONITOR • V$QUEUE • V$SESSION

  19. Choosing a Connection Type • Unless otherwise configured, Oracle Net connections will use: • Shared server if one is available • Dedicated server if a shared server connection is not available • Using local or directory naming, the connection type can be specified as part of the Net service alias.

  20. When Not to Use Shared Server • Certain types of database work should not be performed using shared servers: • Database administration • Backup and recovery operations • Batch processing and bulk load operations • Data warehouse operations Server process Dispatcher

  21. Summary • In this lesson you should have learned how to: • Identify when to use Oracle Shared Servers • Configure Oracle Shared Servers • Monitor Shared Servers

  22. Practice 13 Overview: Oracle Shared Servers • This practice covers the following topics: • Investigating the impact of dedicated server connections on your system • Configuring your system to use shared servers • Investigating the impact of shared server connections on your system

  23. Practice Lesson 13

More Related