select *
from v$sgastat
order by upper(name)

Connect time(ms): 47

Connected to jdbc:oracle:thin:@LarrySERVER:1521:wind
Driver       Oracle JDBC driver
Version      8.1.7.1.0

Query time & data xfer(ms): 0

POOL|NAME|BYTES
shared pool|1M buffer|2098176
|buffer_cache|50331648
shared pool|character set object|318524
shared pool|db_handles|144000
shared pool|dictionary cache|1614976
shared pool|enqueue|213556
shared pool|event statistics per sess|2520000
shared pool|FileIdentificatonBlock|156352
shared pool|FileOpenBlock|438232
shared pool|fixed allocation callback|244
|fixed_sga|454524
shared pool|free memory|46498576
large pool|free memory|16777216
java pool|free memory|8388608
shared pool|joxs heap init|4220
shared pool|KGK heap|2092
shared pool|KGLS heap|217368
shared pool|KQR M PO|157704
shared pool|KQR S PO|17668
shared pool|KQR S SO|2560
shared pool|ksm_file2sga region|370496
shared pool|KSXR large reply queue|166584
shared pool|KSXR pending messages que|841036
shared pool|KSXR receive buffers|1033000
shared pool|library cache|1578596
|log_buffer|3066880
shared pool|message pool freequeue|665792
shared pool|miscellaneous|6395564
shared pool|MTTR advisory |4220
shared pool|PLS non-lib hp|2068
shared pool|processes|192000
shared pool|sessions|543600
shared pool|sim memory hea|25400
shared pool|sql area|621064
shared pool|transaction|264132
shared pool|trigger defini|340
shared pool|trigger inform|624
shared pool|trigger source|100

