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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s