Oracle Shared Servers - Quiz Explanation
The answers you selected are indicated below, along with text that explains the correct answers.
1.
Which of the following is true about configuring a shared server process?
Please select the best answer.
A.
Shared server processes will be allocated automatically when needed, and you should set
mts_shared_servers
to a high initial value.
B.
Shared server processes will be allocated automatically when needed and de-allocated when they are not needed.
C.
Shared server processes will be de-allocated when they are not needed, and you should set
mts_shared_servers
to a high initial value.
The answer is B.
Shared server processes will be allocated automatically when needed and de-allocated when they are not needed.
A is incorrect because, although it’s true that shared server processes will be allocated automatically when needed, you should not set mts_shared_server to a high initial value. C is incorrect for the same reason, even though it’s true that shared server processes will be de-allocated automatically when they are not needed.
2.
What would you do to compute the busy rate for an MTS?
Please select the best answer.
A.
Query the
v$queue
view
B.
Query the
v$dispatcher
view
C.
Run the equation for busy rate
The answer is B.
To compute the busy rate for an MTS, you would query the v$dispatcher view. A is incorrect because the v$queue view only displays tasks awaiting execution. C is incorrect because the equation for busy rate is not used to display Oracle information. D is incorrect because you cannot see the high-water mark for connected processes.
3.
Which of the following views will give you the average wait time per transaction from MTS?
Please select the best answer.
A.
The
v$queue
view
B.
The
v$dispatcher
view
C.
The
v$sga
view
The correct answer is A.
The v$queue view. You will find the average wait time per transaction within the v$queue view. Which of the following views will give you the average wait time per transaction from MTS? B is incorrect because v$dispatcher defines the number of dispatchers. C is incorrect because v$sga only display’s SGA memory usage and does not provide transaction times.