Chapter 5. Oracle Shared Server
ORACLE DATABASE 10G: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Oracle Shared Servers
Identify when to use Oracle Shared Servers.
Configure Oracle Shared Servers.
Monitor Shared Servers.
Describe the shared server architecture.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
As the number of users connecting to Oracle databases in the enterprise grows, the system requirements of the servers increase— particularly the memory and process requirements. When a system starts to encounter these capacity issues, you need to know which alternatives are available within the Oracle environment that can address the problem. One configuration alternative that may help to overcome this capacity problem is Oracle Shared Server.
It is important to understand the Oracle Shared Server architecture and how and when to use it appropriately. When used properly, this feature can help alleviate problems with servers that are being taxed in terms of the number of processes running on the server. When the Shared Server is configured properly, it can help stave off system upgrades that may have seemed imminent, thus saving the organization time and money.
This chapter discusses the Oracle Shared Server and its benefits. You will learn about the client connection process and how Oracle Shared Server processes user requests. You will also learn how to configure Oracle Shared Server and how to manage Oracle Shared Server using various Oracle dynamic performance views. Finally, you will learn where to find information to help you tune the Oracle Shared Server.