After completing this lesson, you should be able to do the following:
Identify issues associated with managing users in an Oracle Shared Server environment
Configure the Oracle Shared Server environment to optimize performance
Diagnose and resolve performance issues with Oracle Shared Server processes
Oracle Server Configuration Options
Oracle creates server processes to handle the requests of user processes connected to an instance. A server process can be either a dedicated server process, where one server process services only one user process, or it can be a shared server process, where a server process can service multiple user processes. Shared server processes are a part of Oracle Shared Server architecture.
Defined by SHARED_POOL_SIZE
Library cache contains statement text, parsed code, and execution plan.
Data dictionary cache contains definitions for tables, columns, and privileges from the data dictionary tables.
UGA contains session information for Oracle Shared Server users when a large pool is not configured.
A profile is a named set of the following password and resource limits:
Password aging and expiration
Password complexity verification
Input/output (I/O) operations
Memory space (private SQL area for Shared Server only)
After a profile has been created, the database administrator can assign it to each user. If resource limits are enabled, the Oracle server limits the database usage and resources to the defined profile of the user....