Oracle Database Administration from Zero to Hero - Managing Database Memory (Part 1 of 2)

This video tutorial covers Oracle Database memory management methods, including Automatic Memory Management (AMM), Automatic Shared Memory Management (ASMM), and manual memory management. It explains how to configure each method, their limitations, and practical implementation steps. AMM is limited to systems with 4GB or less, while ASMM is recommended for production databases. The tutorial also discusses parameters like MEMORY TARGET, SGA TARGET, and PGA AGGREGATE TARGET, and provides best practices for setting these parameters.

What are the three mechanisms provided by Oracle Database for memory management?

• Automatic Memory Management, Dynamic Memory Management, Manual Memory Management

• Shared Memory Management, Dedicated Memory Management, Manual Memory Management

• Dynamic Memory Management, Static Memory Management, Hybrid Memory Management

• Automatic Memory Management, Automatic Shared Memory Management, Manual Memory Management

Why is manual memory management considered impractical?

• It requires setting exact sizes for all memory areas

• It is only supported in older versions of Oracle

• It does not allow for dynamic memory adjustments

• It is not compatible with modern hardware

What is a key limitation of Automatic Memory Management (AMM)?

• It does not allow dynamic adjustment of memory sizes

• It is only applicable when the system memory is 4GB or less

• It requires manual configuration of all memory areas

• It can only be used with databases larger than 4GB

Which parameter must be set to enable AMM?

• MEMORY MAX TARGET

• PGA AGGREGATE TARGET

• MEMORY TARGET

• SGA TARGET

What is the recommended practice for setting the MEMORY MAX TARGET parameter?

• Set it to zero to disable AMM

• Set it to the same value as MEMORY TARGET

• Set it to the maximum possible value after database creation

• Set it to a value less than MEMORY TARGET

What happens if the MEMORY TARGET is set higher than MEMORY MAX TARGET?

• The database will automatically adjust the MEMORY MAX TARGET

• The MEMORY TARGET setting will fail

• The database will not start until the values are corrected

• The database will ignore the MEMORY TARGET setting

How does ASMM differ from AMM in terms of configuration?

• ASMM requires setting MEMORY TARGET to a non-zero value

• ASMM requires separate configuration for SGA and PGA

• ASMM is only applicable for systems with less than 4GB memory

• ASMM does not allow dynamic memory adjustment

What is the purpose of the SGA MAX TARGET parameter in ASMM?

• To set a hard limit on the total memory usage

• To dynamically adjust the SGA size without restarting

• To allocate memory for the PGA

• To prevent the SGA size from exceeding a specified value

What must be done to enable ASMM if AMM is currently enabled?

• Set MEMORY TARGET to zero

• Increase the SGA MAX TARGET

• Restart the database without changing any settings

• Set MEMORY TARGET to a non-zero value

What is the default value for the PGA AGGREGATE LIMIT parameter?

• 50% of the total system memory

• 200% of the PGA AGGREGATE TARGET or 2GB, whichever is larger

• Equal to the SGA TARGET

• 100% of the PGA AGGREGATE TARGET