Oracle Database - Memory

1 - About

Oracle have two Memory spaces:

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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap