Oracle Database Administration from Zero to Hero - Configuring Databases for Shared Server (Part 1 of 3)

The video tutorial explains the differences between dedicated and shared server configurations in Oracle databases. It highlights the benefits and drawbacks of each, using a restaurant analogy to illustrate the shared server process. The shared server configuration reduces memory usage and increases client capacity but may slow response times. Key parameters for configuring shared servers are also discussed.

What is a major drawback of the dedicated server configuration?

• It requires less memory for the PGA.

• It can handle a high number of client processes efficiently.

• It requires a large amount of memory for high client processes.

• It is more complex to set up than shared server configuration.

In shared server configuration, what role do dispatchers play?

• They receive client requests and place them in a queue.

• They manage the database memory allocation.

• They directly handle client requests.

• They execute all database calls for a request.

How does the shared server configuration improve resource efficiency?

• By increasing the number of server processes.

• By reducing the number of server processes needed.

• By dedicating a server process to each client.

• By using more memory for each client process.

What is a potential downside of using shared server configuration?

• It always speeds up response time.

• It cannot handle a high number of concurrent clients.

• It requires more memory than dedicated server configuration.

• It may delay response time in busy systems.

In the hypothetical example, how much memory is saved using shared server configuration for 100 shared server processes?

• 3.6 GB

• 4.4 GB

• 800 MB

• 1.2 GB

What is the recommended starting point for setting the shared servers parameter?

• 1 shared server for each 5 concurrent connections.

• 1 shared server for each 10 concurrent connections.

• 1 shared server for each 20 concurrent connections.

• 1 shared server for each 50 concurrent connections.

What happens if the shared servers parameter is set to 0?

• The shared server is disabled.

• The database spawns more server processes.

• The shared server is enabled.

• The database reduces the number of server processes.

Which memory area is used for user sessions in shared server connections if the large pool is not configured?

• PGA

• SGA

• Shared pool

• BGA

What is a high think application?

• An application that cannot be used with shared server configuration.

• An application that uses a large fraction of its connection time sending calls to the database.

• An application that establishes long-time connections but uses a small fraction of its connection time sending calls.

• An application that requires a dedicated server configuration.

What is the purpose of the Max SHARED SERVERS parameter?

• To limit the maximum number of server processes.

• To allocate memory for each server process.

• To disable the shared server configuration.

• To set the minimum number of server processes.