Originally posted by grjohnson
SELECT * FROM V$SGASIZE;

Everything which SHARED_POOL is variable size
The FIXED_SIZE is space used for some small Oracle processes. The rest is pretty much self expalitory.

Cheers,
V$SGASIZE ???

Let me correct you about the fixed area. It contains atomic variables: latches, pointers into other areas of the SGA. They can be found in X$KSMFSV. These variables (their names) are cryptic and non-important (for me and you).