Difference between revisions of "Oracle Memory Management"
From dbawiki
(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...") |
(No difference)
|
Revision as of 16:53, 29 March 2013
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
