.........[@more@]

View	Description
`V$SGA`	Displays summary information about the system global area (SGA).
`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 400 completed SGA resize operations.
`V$SGA_CURRENT_RESIZE_OPS`	Displays information about SGA resize operations that are currently in progress. A resize operation is an enlargement or reduction of a dynamic SGA component.
`V$SGA_TARGET_ADVICE`	Displays information that helps you tune `SGA_TARGET`. For more information, see Oracle Database Performance Tuning Guide.

ITPub博客

Oracle 10g SGA 相关的VIEW