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.
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).