5.7. Exam Essentials

Define Oracle Shared Server. Be able to list the advantages of Shared Server versus a dedicated server and when it is appropriate to consider both options.

Understand the architecture of the Oracle Shared Server. Be able to summarize the steps that a client takes to initiate a connection with a shared server and the processes behind those steps. Understand what happens during client request processing, and outline the steps.

Understand the changes that are made in the SGA and the PGA. Make sure you understand that in a Shared Server environment, many PGA structures are moved in the Large Pool inside the SGA. This means that the SGA will become larger and that the Large Pool will need to be configured in the init.ora file.

Know how to configure the Oracle Shared Server. Be able to define each of the parameters involved in the configuration of Oracle Shared Server. Know what parameters can be dynamically modified and what parameters require the Oracle instance to be restarted to take effect.

Know how to configure clients running in Shared Server mode. Be able to configure clients that need a dedicated connection to Oracle if it is running in Shared Server mode.

Know which views to use to monitor the Shared Server performance. Be able to use the available V$ views to monitor and tune the Shared Server and know how to adjust settings when necessary.