Less 13
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Less 13 as PDF for free.
More details
- Words: 755
- Pages: 22
Oracle Shared Servers
Copyright © 2004, Oracle. All rights reserved.
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
Copyright © 2004, Oracle. All rights reserved.
Establishing a Connection
Incoming connection request Listener Copyright © 2004, Oracle. All rights reserved.
Dedicated Server Process
Server process
User process
Listener Copyright © 2004, Oracle. All rights reserved.
User Sessions
Server process User Session
PGA
User process
Listener Copyright © 2004, Oracle. All rights reserved.
User Sessions: Dedicated Server User sessions
Server process Server process User session
Server process
Copyright © 2004, Oracle. All rights reserved.
User Sessions: Shared Server
Server process
Dispatcher
Listener
Copyright © 2004, Oracle. All rights reserved.
Processing a Request Shared server processes
4
S000
Response queue for D000 Response queue for D001 Response queue for D002
Common request queue for all dispatchers
S001
3
S002
Instance SGA
2
5
Dispatcher D000
Dispatcher D001
Database server
6 1
User process
Dispatcher D002
User process
Copyright © 2004, Oracle. All rights reserved.
Client or middle tier
The SGA and PGA
Dedicated server: User session data is kept in the PGA. SGA
PGA
Shared pool and other memory structures
User Stack Cursor session space state data
Oracle Shared Server: User session data is held in the SGA. SGA User Cursor Shared pool and other memory session state structures data
Copyright © 2004, Oracle. All rights reserved.
PGA Stack space
Configuring Oracle Shared Server
Required parameter • DISPATCHERS
Optional parameters • • • •
SHARED_SERVERS MAX_SHARED_SERVERS CIRCUITS SHARED_SERVER_SESSIONS
Copyright © 2004, Oracle. All rights reserved.
DISPATCHERS
Specifies the number of dispatchers that are initially started for a given protocol. DISPATCHERS = “(PROTOCOL=TCP)(DISPATCHERS=2) \ (PROTOCOL=IPC)(DISPATCHERS=1)”
Dispatcher D000
Dispatcher D001
Dispatcher D002
TCP/IP
TCP/IP
IPC
Copyright © 2004, Oracle. All rights reserved.
SHARED_SERVERS
Specifies the number of shared server processes created when an instance is started up, and retained during instance operation.
SHARED_SERVERS = 6 S000
S002
S004
S001
S003
S005
Copyright © 2004, Oracle. All rights reserved.
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 S000
S002
S004
S006
S008
S001
S003
S005
S007
S009
Copyright © 2004, Oracle. All rights reserved.
CIRCUITS
•
•
Specifies the total number of virtual circuits that are available for inbound and outbound network sessions Contributes to total SGA size
CIRCUITS = 100
Copyright © 2004, Oracle. All rights reserved.
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
Copyright © 2004, Oracle. All rights reserved.
Related Parameters
Other initialization parameters affected by Oracle Shared Server that may require adjustment: • LARGE_POOL_SIZE • SESSIONS • PROCESSES • LOCAL_LISTENER
Copyright © 2004, Oracle. All rights reserved.
Verifying Shared Server Setup
•
Verify that the dispatcher has registered with the listener when the database was started by issuing: $ lsnrctl SERVICES
•
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.
Copyright © 2004, Oracle. All rights reserved.
Data Dictionary Views
• • • • • •
V$CIRCUIT V$SHARED_SERVER V$DISPATCHER V$SHARED_SERVER_MONITOR V$QUEUE V$SESSION
Copyright © 2004, Oracle. All rights reserved.
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.
Copyright © 2004, Oracle. All rights reserved.
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
Dispatcher
Server process
Copyright © 2004, Oracle. All rights reserved.
Summary
In this lesson you should have learned how to: • Identify when to use Oracle Shared Servers • Configure Oracle Shared Servers • Monitor Shared Servers
Copyright © 2004, Oracle. All rights reserved.
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
Copyright © 2004, Oracle. All rights reserved.
Copyright © 2004, Oracle. All rights reserved.
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
Copyright © 2004, Oracle. All rights reserved.
Establishing a Connection
Incoming connection request Listener Copyright © 2004, Oracle. All rights reserved.
Dedicated Server Process
Server process
User process
Listener Copyright © 2004, Oracle. All rights reserved.
User Sessions
Server process User Session
PGA
User process
Listener Copyright © 2004, Oracle. All rights reserved.
User Sessions: Dedicated Server User sessions
Server process Server process User session
Server process
Copyright © 2004, Oracle. All rights reserved.
User Sessions: Shared Server
Server process
Dispatcher
Listener
Copyright © 2004, Oracle. All rights reserved.
Processing a Request Shared server processes
4
S000
Response queue for D000 Response queue for D001 Response queue for D002
Common request queue for all dispatchers
S001
3
S002
Instance SGA
2
5
Dispatcher D000
Dispatcher D001
Database server
6 1
User process
Dispatcher D002
User process
Copyright © 2004, Oracle. All rights reserved.
Client or middle tier
The SGA and PGA
Dedicated server: User session data is kept in the PGA. SGA
PGA
Shared pool and other memory structures
User Stack Cursor session space state data
Oracle Shared Server: User session data is held in the SGA. SGA User Cursor Shared pool and other memory session state structures data
Copyright © 2004, Oracle. All rights reserved.
PGA Stack space
Configuring Oracle Shared Server
Required parameter • DISPATCHERS
Optional parameters • • • •
SHARED_SERVERS MAX_SHARED_SERVERS CIRCUITS SHARED_SERVER_SESSIONS
Copyright © 2004, Oracle. All rights reserved.
DISPATCHERS
Specifies the number of dispatchers that are initially started for a given protocol. DISPATCHERS = “(PROTOCOL=TCP)(DISPATCHERS=2) \ (PROTOCOL=IPC)(DISPATCHERS=1)”
Dispatcher D000
Dispatcher D001
Dispatcher D002
TCP/IP
TCP/IP
IPC
Copyright © 2004, Oracle. All rights reserved.
SHARED_SERVERS
Specifies the number of shared server processes created when an instance is started up, and retained during instance operation.
SHARED_SERVERS = 6 S000
S002
S004
S001
S003
S005
Copyright © 2004, Oracle. All rights reserved.
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 S000
S002
S004
S006
S008
S001
S003
S005
S007
S009
Copyright © 2004, Oracle. All rights reserved.
CIRCUITS
•
•
Specifies the total number of virtual circuits that are available for inbound and outbound network sessions Contributes to total SGA size
CIRCUITS = 100
Copyright © 2004, Oracle. All rights reserved.
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
Copyright © 2004, Oracle. All rights reserved.
Related Parameters
Other initialization parameters affected by Oracle Shared Server that may require adjustment: • LARGE_POOL_SIZE • SESSIONS • PROCESSES • LOCAL_LISTENER
Copyright © 2004, Oracle. All rights reserved.
Verifying Shared Server Setup
•
Verify that the dispatcher has registered with the listener when the database was started by issuing: $ lsnrctl SERVICES
•
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.
Copyright © 2004, Oracle. All rights reserved.
Data Dictionary Views
• • • • • •
V$CIRCUIT V$SHARED_SERVER V$DISPATCHER V$SHARED_SERVER_MONITOR V$QUEUE V$SESSION
Copyright © 2004, Oracle. All rights reserved.
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.
Copyright © 2004, Oracle. All rights reserved.
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
Dispatcher
Server process
Copyright © 2004, Oracle. All rights reserved.
Summary
In this lesson you should have learned how to: • Identify when to use Oracle Shared Servers • Configure Oracle Shared Servers • Monitor Shared Servers
Copyright © 2004, Oracle. All rights reserved.
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
Copyright © 2004, Oracle. All rights reserved.
Related Documents
Less 13
November 2019 16
Napoleaon Hill Less 13 & 14
July 2020 12
Less
October 2019 32
Pulse Less
June 2020 14
Less 16
November 2019 15