Table of Contents

About

Oracle have two Memory spaces:

Example of configuration changes

With SQLPlus

shutdown immediate
startup nomount
ORACLE instance started.
Total System Global Area | 1570009088 | bytes
Fixed Size               |    2403064 | bytes
Variable Size            |  939525384 | bytes
Database Buffers         |  620756992 | bytes
Redo Buffers             |    7323648 | bytes

alter system set memory_max_target=500m scope=spfile;
alter system set memory_target=500m scope=spfile;
shutdown 
startup
ORACLE instance started.
Total System Global Area |  521936896 | bytes
Fixed Size               |    2404552 | bytes
Variable Size            |  427822904 | bytes
Database Buffers         |   83886080 | bytes
Redo Buffers             |    7823360 | bytes