SQL> select * from v$sgastat;
POOLNAME
BYTES
----------- -------------------------- ---------------------------------------------
fixed_sga
777224
buffer_cache
15737028608
log_buffer
4457472
shared pool errors
152968
shared pool enqueue
2688776
shared pool subheap
25456
shared pool DML lock
1919872
shared pool KGK heap
80600
shared pool KQR L PO
4112256
shared pool KQR M PO
139206904
shared pool KQR S SO
8192
shared pool KQR X PO
25760
shared pool sessions
1146496
shared pool sql area
379042584
shared pool 1M buffer
1056768
shared pool KGLS heap
3843880
shared pool processes
1502208
shared pool PX subheap
1048616
shared pool db_handles
1336320
shared pool parameters
105704
shared pool free memory
293953704
shared pool gcs shadows
98996864
shared pool PL/SQL DIANA
3631936
shared pool ges enqueues
297316544
shared pool FileOpenBlock
16104056
shared pool PL/SQL MPCODE
2177344
shared pool PL/SQL PPCODE
332496
shared pool PL/SQL SOURCE
2088
shared pool gcs resources
149005056
shared pool ges resources
260981576
shared pool library cache
356750616
shared pool miscellaneous
348116272
shared pool KCL name table
5566152
shared pool MTTR advisory
213592
shared pool PLS non-lib hp
2528
shared pool XDB Schema Cac
7631960
shared pool joxlod: in ehe
421008
shared pool joxs heap init
1104
shared pool partitioning d
68209448
shared pool sim memory hea
6480408
shared pool table definiti
54696
shared pool temporary tabl
18446744073709550104
shared pool trigger defini
2608
shared pool trigger inform
3416
shared pool trigger source
2744
shared pool Checkpoint queue
76815360
shared pool dictionary cache
3229952
shared pool enqueue resources
1826208
shared pool ges process array
1475840
shared pool ges big msg buffers
5311272
shared pool ktlbk state objects
749864
shared pool KSXR receive buffers
1034000
shared pool db_block_hash_buckets
30472816
shared pool FileIdentificatonBlock
2809104
shared pool gcs resource hash table
1048576
shared pool ges regular msg buffers
1236600
shared pool ges resource hash table
4325376
shared pool ges reserved msg buffers
2096008
shared pool event statistics per sess
14388864
shared pool fixed allocation callback
1888
shared pool replication session stats
386688
large poolPX msg pool
536311536
large poolfree memory
559376
java pool free memory
111398912
java pool memory in use
6041600
65 rows selected.
