Summary of Memory Management Methods
Summary of Memory Management Methods
Table 18-1 summarizes the various memory management methods. If you do not enable automatic memory management, then you must separately configure one memory management method for the SGA and one for the PGA.
Note:
When automatic memory management is not enabled, the default method for the instance PGA is automatic PGA memory management.
Table 18-1 Memory Management Methods
Instance | SGA | PGA | Description | Initialization Parameters |
---|---|---|---|---|
Auto |
n/a |
n/a |
The database tunes the size of the instance based on a single instance target size. |
You set:
|
n/a |
Auto |
Auto |
The database automatically tunes the SGA based on an SGA target. The database automatically tunes the PGA based on a PGA target. |
You set:
|
n/a |
Auto |
Manual |
The database automatically tunes the SGA based on an SGA target. You control the PGA manually, setting the maximum work area size for each type of SQL operator. |
You set:
|
n/a |
Manual |
Auto |
You control the SGA manually by setting individual component sizes. The database automatically tunes the PGA based on a PGA target. |
You set:
|
n/a |
Manual |
Manual |
You must manually configure SGA component sizes. You control the PGA manually, setting the maximum work area size for each type of SQL operator. |
You must manually configure SGA component sizes. You set:
|
See Also:
Oracle Database Administrator's Guide because automatic memory management is not available on all platforms
最新文章
- strcpy strlen memcpy等的函数实现
- struts之动态方法调用改变表单action属性
- Android组件间交互
- ASP.NET MVC 的自定义模型属性别名绑定
- Ext.net 异常统一管理,铥掉可恶的 Request Failure
- iOS App Icon图标 尺寸规范
- jquery api调用
- backbone todo example
- Exchange模式功能
- 基于visual Studio2013解决C语言竞赛题之0905文件读写显示
- Installutil.exe的位置和路径
- UITableView 之 取消选中
- php使用ZipArchive压缩文件的心得
- JDBC连接数据库(查询)的步骤
- php 获取URL 各部分参数
- 好用的开源库(一)——MaterialEditText
- WPFの阴影效果
- C语言实现程序跳转到绝对地址0x100000处执行
- Vue学习笔记八:v-for,v-if,v-show指令
- C++中的memset、zeroMemory和={0}操作( 转)
热门文章
- job调度时间格式
- 【Cocos2dx】Windows平台下Cocos2dx 2.x的下载、安装、配置,打造自己的Helloworld
- SQL Server2012 T-SQL基础教程--读书笔记(5-7章)
- 洛谷 P2129 L国的战斗续之多路出击(模拟)
- BZOJ 2333 左偏树 (写得我人生都崩溃了...)
- POJ 1118 求平面上最多x点共线
- HTML <;!DOCTYPE>;标签
- ViewPager PagerAdapter 的使用
- AI:IPPR的数学表示-CNN可视化语义分析
- VTK嵌入MFC同步显示