Dynamics views for SGA

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.

set lin 180

col component format A50

select START_TIME, component, oper_type, oper_mode,status, initial_size/1024/1024 "INITIAL", target_size/1024/1024 "TARGET", FINAL_SIZE/1024/1024 "FINAL", END_TIME

from v$sga_resize_ops where status='ERROR'

order by start_time, component

col current_size for 999,999,999,999 head "Current Size"

col min_size for 999,999,999,999 head "Min Size"

col max_size for 999,999,999,999 head "Max Size"

select COMPONENT,CURRENT_SIZE,MIN_SIZE,MAX_SIZE,USER_SPECIFIED_SIZE from V$SGA_DYNAMIC_COMPONENTS order by COMPONENT;