ITPub博客

首页 > 数据库 > Oracle > About Automatic Shared Memory Management

About Automatic Shared Memory Management

翻译 Oracle 作者:wanghanjun 时间:2015-12-31 10:47:50 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-05-28

  • 博文量
    42
  • 访问量
    32102