******************************************************************************** * Description: SQL for Querying SGA Utilization Divided by Individule Component * Compatiablity: RDBMS 10g, 11g, 12c * Date: 04:32 PM EST, 03/08/2017 ******************************************************************************** SQL> select sum(bytes)/1024/1024 " SGA size used in MB" from v$sgastat where name!='free memory'; SGA size used in MB -------------------- 20573.4386 SQL> select * from v$sgastat; POOL NAME BYTES ------------ -------------------------- ---------- large pool krcc extent chunk 4145152 large pool PX msg pool 8192000 large pool CTWR dba buffer 1527808 large pool free memory 53243904 java pool free memory 260194048 java pool JOXLE 8080128 java pool joxs heap 161280 streams pool spilled:kwqbl 256 streams pool kwqbsinfy:bms 7712 streams pool free memory 134161112 streams pool fixed allocation callback 448 streams pool image handles 8640 streams pool kgqmdm_fl_1 4352 streams pool kwqbsinfy:bqg 1232 streams pool kwqbsinfy:sta 960 streams pool kwqbsinfy:cco 376 streams pool kwqbsinfy:mpr 32640
Your Comments