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 new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF