Oracle
1Z0-062 · Question #380
All of your database instances use SPFILES. You executed this command in one of them: ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?
The correct answer is C. The parameter is modified in the parameter file only. https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN00207
Managing the Database Instance
Question
All of your database instances use SPFILES. You executed this command in one of them:
ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M; Which statement is true?
Options
- AThe parameter is modified in memory and in the parameter file.
- BThe command returns an error.
- CThe parameter is modified in the parameter file only.
- DThe parameter is modified in memory only.
How the community answered
(24 responses)- A4% (1)
- B4% (1)
- C83% (20)
- D8% (2)
Explanation
https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN00207
Topics
#SPFILE#ALTER SYSTEM#MEMORY_MAX_TARGET#parameter persistence
Community Discussion
No community discussion yet for this question.