The SGA_MAX_SIZE initialization parameter specifies the maximum size of the System
Global Area for the lifetime of the instance. You can dynamically alter the initialization
parameters affecting the size of the buffer caches, shared pool, large pool, Java pool,
and streams pool but only to the extent that the sum of these sizes and the sizes of the
other components of the SGA (fixed SGA, variable SGA, and redo log buffers) does not
exceed the value specified by SGA_MAX_SIZE.
If you do not specify SGA_MAX_SIZE, then Oracle Database selects a default value that
is the sum of all components specified or defaulted at initialization time. If you do
specify SGA_MAX_SIZE, and at the time the database is initialized the value is less
than the sum of the memory allocated for all components, either explicitly in the
parameter file or by default, then the database ignores the setting for SGA_MAX_SIZE.
限制SGA的大小
1. 当oracle初始化启动时,如果sga_max_size的值小于显式的指定的各sga组件值之和,则oracle将
会忽略sga_max_size
2. 当oracle初始化启动时,如果sga_max_size小于sga_target时,启动之后,sga_max_size将等于
sga_target
3. 启动之后,sga_target就不能大于sga_max_size.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-996002/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002850
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
