Oracle Database - Memory

> Database > Oracle Database

1 - About

Oracle have two Memory spaces:

Advertising

3 - 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
db/oracle/memory.txt · Last modified: 2018/12/11 20:29 by gerardnico