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 is the recommended action if the AMM is enabled when configuring the ASMM?

Evaluate responses using AI:

OFF

What workaround is suggested if there is an error due to insufficient physical memory when setting the BGA?

Evaluate responses using AI:

OFF