Monday , December 4 2023

Configure Automatic Memory Management in Oracle

To configure Automatic Memory Management(AMM) in databases that do not use AMM, it is necessary to change the required parameters and restart the database.

When AMM is active in Oracle databases, if the memory values grow and shrink too frequently, “database: pin S wait on X” or “library cache lock” wait events can be observed in the database. In such a case, you can find what needs to be done in the “Effects of Very Frequent Growth and Shrink Operations on Automatic Memory Management(AMM)” article.

Change the parameter:

When changing parameters in RAC systems, sid = ‘*’ must be added to the end.

The database needs to be restarted after you change the parameter.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *