Oracle Memory Management

From dbawiki
Revision as of 16:53, 29 March 2013 by Stuart (talk | contribs) (Created page with "Options are: * Leave it completely up to the database then just set memory_max_size and memory_target * Set minimum values for some components then set values for pga_aggregat...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Options are:

  • Leave it completely up to the database

then just set memory_max_size and memory_target

  • Set minimum values for some components

then set values for pga_aggregate_target and/or sga_target

  • Set maximum values for some components

then set values for things like sga_max_size

Handy views to look at

V$SGAINFO
V$SGASTAT
V$SGA_DYNAMIC_COMPONENTS
Retrieved from "https://mailnest.com/dbawiki/index.php?title=Oracle_Memory_Management&oldid=497"