SELECT * FROM V$SGASTAT Connect time(ms): 15 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 |fixed_sga|454744 |buffer_cache|125829120 |log_buffer|3066880 shared pool|enqueue|213556 shared pool|KGK heap|2092 shared pool|KQR L SO|59392 shared pool|KQR M PO|210976 shared pool|KQR M SO|32768 shared pool|KQR S PO|21504 shared pool|KQR S SO|3584 shared pool|sessions|543600 shared pool|sql area|1298832 shared pool|1M buffer|2098176 shared pool|KGLS heap|7154780 shared pool|processes|192000 shared pool|parameters|6264 shared pool|free memory|9491236 shared pool|transaction|264132 shared pool|PL/SQL DIANA|490408 shared pool|FileOpenBlock|438232 shared pool|PL/SQL MPCODE|699016 shared pool|library cache|3687436 shared pool|miscellaneous|7616276 shared pool|MTTR advisory |16928 shared pool|PLS non-lib hp|2944 shared pool|joxs heap init|4220 shared pool|sim memory hea|29636 shared pool|table definiti|56 shared pool|trigger defini|340 shared pool|trigger inform|504 shared pool|trigger source|100 shared pool|dictionary cache|1614976 shared pool|ksm_file2sga region|370496 shared pool|KSXR receive buffers|1033000 shared pool|character set object|318524 shared pool|message pool freequeue|665792 shared pool|KSXR pending messages que|841036 shared pool|event statistics per sess|2520000 shared pool|fixed allocation callback|228 large pool|free memory|16777216 java pool|free memory|159383552