About Automatic Shared Memory Management

Automatic Shared Memory Management simplifies SGA memory management. You specify the total amount of SGA memory available to an instance using the SGA_TARGET initialization parameter and Oracle Database automatically distributes this memory among the various SGA components to ensure the most effective memory utilization.
自动共享内存管理简化了SGA内存管理的步骤.你可以指定一个SGA的总值然后Oracle会自动分配内存来保证最有效的内存使用

When automatic shared memory management is enabled, the sizes of the different SGA components are flexible and can adapt to the needs of a workload without requiring any additional configuration. The database automatically distributes the available memory among the various components as required, allowing the system to maximize the use of all available SGA memory.
当自动共享内存管理启动以后,SGA不同组件的大小也会随时变化一边适用于不同的负载.数据库自动跳陪调配可用的内存,允许系统最大程度的使用SGA

If you are using a server parameter file (SPFILE), the database remembers the sizes of the automatically tuned SGA components across instance shutdowns. As a result, the database instance does not need to learn the characteristics of the workload again each time the instance is started. The instance can begin with information from the previous instance and continue evaluating workload where it left off at the last shutdown.
如果你用SPFILE,数据库会记录自动调整的SGA的值在shutdown过程中,其好处是数据库在每次启动的时候不需要再次计算workload而是直接使用这些信息

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8747612/viewspace-1969011/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/8747612/viewspace-1969011/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值