Oracle
1Z0-072 · Question #21
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value. Which three actions could help in handling a large number of concurrent users?
The correct answer is B. setting the LARGE_POOL_SIZE parameter to a non-zero value C. increasing the size of the PGA D. setting the SHARED_POOL_SIZE parameter to a non-zero value. See the full explanation below for the reasoning.
Question
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value. Which three actions could help in handling a large number of concurrent users?
Options
- Ausing Automatic SGA Memory Management (ASMM)
- Bsetting the LARGE_POOL_SIZE parameter to a non-zero value
- Cincreasing the size of the PGA
- Dsetting the SHARED_POOL_SIZE parameter to a non-zero value
- Eincreasing the number of dispatchers
How the community answered
(36 responses)- A19% (7)
- B72% (26)
- E8% (3)
Community Discussion
No community discussion yet for this question.