1Z0-062 · Question #286
Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following: 1. Parallel execution messages and control structures 2. Local variables f
The correct answer is D. 1, 2, and 4. This question asks to identify what specific components are allocated from the large pool when Automatic Memory Management is enabled and shared server connections are supported.
Question
Options
- Aonly 1
- B1, 2, and 5
- C1, 2, 3, and 5
- D1, 2, and 4
How the community answered
(53 responses)- A9% (5)
- B4% (2)
- C13% (7)
- D74% (39)
Why each option
This question asks to identify what specific components are allocated from the large pool when Automatic Memory Management is enabled and shared server connections are supported.
This option is incomplete as the large pool also handles local variables for shared server processes and runtime memory values for I/O buffers.
The large pool is primarily used for shared server connections to store local variables and for parallel execution message buffers and control structures. Additionally, it can store runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan, especially in certain I/O buffer scenarios.
Concept tested: Oracle large pool allocations
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-E138E662-7934-4C3D-882E-2D13A465B2B8
Topics
Community Discussion
No community discussion yet for this question.