What to do after increasing the Memory of Oracle Database

This article discusses What to do after increasing the Memory of Oracle Database. After altering (increasing) the ‘memory max target’ and ‘memory target’ of an Oracle database, you will have to run these statements as sysdba to restart the database. By not doing so, you will not have the necessary permission to perform some necessary tasks. Please see How to Increase Disk Size in Hyper-V, How to uninstall Oracle Database 11G or 12c, and How to run Windows Memory Diagnostics Tool on Windows.

Also, see How to install Oracle VirtualBox on a Mac device, how to Create a web page to visualize the output of BitLocker Script, and How to update Object First OOTBI Cluster.

Post Oracle Database Memory Increase

Sysdba grants the necessary privilege to administer the database. Please also see How to upgrade Veeam Backup and Replication 12.3.

This requires a restart and you do not necessarily have to restart the whole Database. If it is in production, simply follow these commands after modifying the ‘memory_max_target’ and ‘memory_target’ value of the Oracle Db. Simply run in sqlplus

sysys /as sysdba

Next

shutdown immediate

Next, enter the command as fast as possible

startup

This will ensure the changes are applied to the database. Test to ensure the parameters are okay and changes propagated correctly.

show parameter memory

Also, see how to Create a web page to visualize the output of BitLocker Script, how to Query and display Windows information via WMI Explorer, and how to Fix unable to start the Application Identity Service.

I hope you found this article very useful. Please feel free to leave a comment below.