select * from v$sgastat order by upper(name) Connect time(ms): 78 Connected to jdbc:oracle:thin:@lfpplm: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|125829120 shared pool|character set object|318524 shared pool|dictionary cache|1614976 shared pool|enqueue|213556 shared pool|event statistics per sess|2520000 shared pool|FileOpenBlock|438232 shared pool|fixed allocation callback|228 |fixed_sga|454744 shared pool|free memory|11808544 java pool|free memory|159383552 large pool|free memory|16777216 shared pool|joxs heap init|4220 shared pool|KGK heap|2092 shared pool|KGLS heap|7052388 shared pool|KQR L SO|59392 shared pool|KQR M PO|166944 shared pool|KQR M SO|32768 shared pool|KQR S PO|20480 shared pool|KQR S SO|3584 shared pool|ksm_file2sga region|370496 shared pool|KSXR pending messages que|841036 shared pool|KSXR receive buffers|1033000 shared pool|library cache|3168196 |log_buffer|3066880 shared pool|message pool freequeue|665792 shared pool|miscellaneous|7553412 shared pool|MTTR advisory |16928 shared pool|PL/SQL DIANA|379740 shared pool|PL/SQL MPCODE|24548 shared pool|PLS non-lib hp|2944 shared pool|processes|192000 shared pool|sessions|543600 shared pool|sim memory hea|29636 shared pool|sql area|502792 shared pool|transaction|264132 shared pool|trigger defini|168 shared pool|trigger inform|472 shared pool|trigger source|44