********************************************************************************
* 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