Answer to Question #272980 in Databases | SQL | Oracle | MS Access for rosebud21

Question

To accomplish automated memory management, Oracle uses two initialisation parameters. Explain the two initialisation parameters used to accomplish memory management then provide an advantage of using automatic memory management over manual memory management (5 marks)

Answer 1

Automatic memory management is configured using two new initialization parameters:

• MEMORY_TARGET: The amount of shared memory available for Oracle to use when dynamically controlling the SGA and PGA. This parameter is dynamic, so the total amount of memory available to Oracle can be increased or decreased, provided it does not exceed the MEMORY_MAX_TARGET limit. The default value is "0".
• MEMORY_MAX_TARGET: This defines the maximum size the MEMORY_TARGET can be increased to without an instance restart. If the MEMORY_MAX_TARGET is not specified, it defaults to MEMORY_TARGET setting.

The advantages of automatic memory management are:

• the programmer is freed to work on the actual problem;
• module interfaces are cleaner;
• there are fewer memory management bugs;
• memory management is often more efficient.