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.

Sysdba grants the necessary privilege to administer the database.

Note: This requires a restart and do not necessarily have to restart the whole Db if it is in production, simply follow these commands before 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