1Z0-067 · Question #159
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command: SQL> ALTER SYSTEM SET…
The correct answer is A. The minimum size for the standard buffer cache is 100 MB. https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams043.htm#REFRN10033 If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value…
Question
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined. You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M; Which statement is true?
Options
- AThe minimum size for the standard buffer cache is 100 MB.
- BThe maximum size for the standard buffer cache is 100 MB.
- CThe minimum space guaranteed in the buffer cache for any server process is 100 MB.
- DThe maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
- EThe minimum size for all buffer caches is 100 MB.
How the community answered
(33 responses)- A79% (26)
- B6% (2)
- D12% (4)
- E3% (1)
Explanation
https://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams043.htm#REFRN10033 If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.
Topics
Community Discussion
No community discussion yet for this question.