ITPub博客

首页 > 应用开发 > IT综合 > Control of the SGA’s Use of Memory (95)

Control of the SGA’s Use of Memory (95)

原创 IT综合 作者:tsinglee 时间:2007-10-25 11:02:54 0 删除 编辑

Dynamic SGA provides external controls for increasing and decreasing Oracle’s use of
physical memory. Together with the dynamic buffer cache, shared pool, and large
pool, dynamic SGA allows the following:
■ The SGA can grow in response to a database administrator statement, up to an
operating system specified maximum and the SGA_MAX_SIZE specification.
■ The SGA can shrink in response to a database administrator statement, to an
Oracle prescribed minimum, usually an operating system preferred limit.
■ Both the buffer cache and the SGA pools can grow and shrink at runtime
according to some internal, Oracle-managed policy.

动态SGA
动态增在至SGA_MAX_SIZE指定的值, 回缩直至Oracle prescribed minimum
in response to:响应

[@more@]

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

上一篇: Streams Pool (94)
请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892802