Search notes:

Oracle Memory Management

Memory management deals with determining the optimal size for the instance memory structures of the

SGA and
instance PGA.

For both areas, management can be set to

automatic or
manual

With automatic memory management, the memory of the SGA and PGA are adjusted and fine tuned by Oracle.

Two init parameters are needed for automatic memory management:

memory_target
memory_max_target (which is even optional)

Init parameters related to memory management

Init parameters that are related to memory management are:

inmemory_size
memory_target
memory_max_target
memoptimize_pool_size
pga_aggregate_limit
pga_aggregate_target
result_cache_max_size
bitmap_merge_area_size
create_bitmap_area_size
hash_area_size
sort_area_size
workarea_size_policy
cursor_space_for_time
db_block_buffers
lock_sga
shared_memory_address
hi_shared_memory_address
trace_enabled

See also

Too little memory or ill allocated memory might lead to peformance problems, see performance and tuning.

dbms_session.free_unused_user_memory and dbms_session.get_package_memory_utilization.