The following Oracle 10g views provide information about the SGA components and their dynamic resizing.
v$sga - Displays summary information about the system global area (SGA).
v$sga_target_advice - Displays information that helps you tune SGA_TARGET.
v$sga_target_advice - Displays information that helps you tune SGA_TARGET.
v$sgainfo - Displays size information about the SGA, including the sizes of different SGA components, the granule size, and free memory.
v$sgastat - Displays detailed information about the SGA.
v$sga_dynamic_components - Displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup.
v$sga_dynamic_free_memory - Displays information about the amount of SGA memory available for future dynamic SGA resize operations.
v$sga_resize_ops - Displays information about the last 100 completed SGA resize operations.
v$sga_current_resize_ops - Displays information about SGA resize operations which are currently in progress. An operation can be a grow or a shrink of a dynamic SGA component.
v$sgastat - Displays detailed information about the SGA.
v$sga_dynamic_components - Displays information about the dynamic SGA components. This view summarizes information based on all completed SGA resize operations since instance startup.
v$sga_dynamic_free_memory - Displays information about the amount of SGA memory available for future dynamic SGA resize operations.
v$sga_resize_ops - Displays information about the last 100 completed SGA resize operations.
v$sga_current_resize_ops - Displays information about SGA resize operations which are currently in progress. An operation can be a grow or a shrink of a dynamic SGA component.
Last updated: 2009-Oct-19, Monday |
0 评论:
Post a Comment