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

The video tutorial covers the configuration of ASMM in SRP One, focusing on memory allocation for the database. It explains the distribution of memory between SGA and PGA, and addresses issues encountered when setting memory parameters due to insufficient physical memory. A workaround involving the SP file is implemented to resolve these issues. The tutorial also discusses querying memory target advisors and concludes with recommendations for using ASMM and querying advisor views for optimal memory sizes.

What percentage of the total physical memory is allocated to the database in the ASMM configuration?

• 70%

• 80%

• 60%

• 50%

What is the workaround for the bug encountered when setting the BGA size?

• Disable the SGA

• Use a different database instance

• Increase the physical memory

• Set the parameter value in the SP file and restart

What is the role of the memory target advisor when AMM is disabled?

• It enables AMM

• It returns no rows

• It increases the SGA size

• It provides memory allocation suggestions

Why is it recommended to use ASMM over AMM?

• AMM is not supported

• ASMM is more stable

• ASMM provides better performance

• ASMM is easier to configure

What should be done if the database is under normal stress for a long time?

• Restart the database

• Increase the physical memory

• Query the ASMM target advisor

• Disable the AMM