Performance Tuning - Question 119

Oracle Shared Server is best used when _____ and _____. (Choose two)

A. The database is experiencing database-intensive work.

B. The database is primary used for batch or DSS operations.

C. CPU usage on your machine is consistently at 90% or higher.

D. An OLTP application is running on a machine approaching memory resource limits.

E. You do not need to scale up the number of concurrent connections to the database.

F. The database is primary used for an interactive application where dedicated servers are mainly idle.

Answer: D, F

Explanation:

Oracle Shared Server configuration will be very helpful when an OLTP application is running on a machine approaching memory resource limits or the database is primary used for an interactive application where dedicated servers are mainly idle. The idle server process is holding system resources. The shared server architecture eliminates the need for a dedicated server process for each connection

Incorrect Answers

A: If the database is experiencing database-intensive work all dedicated servers are busy. But Oracle Shared Server architecture is more useful when dedicated servers are mainly idle.

B: The Oracle Shared Server configuration is more useful for OLTP systems with many DML operations, not for DSS environment with long-running transactions.

C: Oracle Shared Server will be not the best in this situation.

E: It is required when you NEED to scale up the number of concurrent connections to the database.

OCP: Oracle 9i Performance Tuning Study Guide, Jaseph C. Johnson, p. 517-547

Chapter 10: Operating System Tuning