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

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@]
请使用浏览器的分享功能分享到微信等