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_MAX_SIZE指定的值, 回缩直至Oracle prescribed minimum
in response to:响应
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-978522/，如需转载，请注明出处，否则将追究法律责任。