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

最新推荐文章于 2025-12-09 09:24:19 发布

转载最新推荐文章于 2025-12-09 09:24:19 发布 · 82 阅读

文章标签：

#数据库 #runtime

本文介绍了Oracle数据库中动态SGA（系统全局区）的内存管理特性。动态SGA允许数据库管理员通过外部控制来增加或减少Oracle使用的物理内存，并且可以在运行时根据内部策略动态调整缓冲区缓存和SGA池的大小。

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

转载于:http://blog.itpub.net/10599713/viewspace-978522/