V$SGASTAT

Oracle 11gR1

V$SGASTAT displays detailed information on the system global area (SGA).

Column	Datatype	Description
POOL	VARCHAR2(12)	Designates the pool in which the memory in NAME resides: · shared pool - Memory is allocated from the shared pool · large pool - Memory is allocated from the large pool · java pool - Memory is allocated from the Java pool · streams pool - Memory is allocated from the Streams pool
NAME	VARCHAR2(26)	SGA component name
BYTES	NUMBER	Memory size (in bytes)

Note:

select * from V$SGASTAT order by pool, name;

POOL	NAME	BYTES
java pool	free memory	312166720
java pool	joxlod exec hp	6459264
java pool	joxs heap	141120
large pool	PX msg pool	1076000
large pool	free memory	166696160
shared pool	1:kngisga	32088
shared pool	AQ Propagation Scheduling	16000
shared pool	ASH buffers	30408704
shared pool	ASM file	19200
……	……	……

The following views provide information about the SGA components and their dynamic resizing.

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.

Oracle dynamic performance views