Free size in SGA

[paragp1981]

hi,
Can we have any view or datadictionary,query by which we could get to know. How much space is free out of our sga.

Rgds
Parag

[hrishy]

Hi

SQL> select round((sum(decode(name, 'free memory', bytes, 0))))
  2  from v$sgastat
  3
SQL>
SQL> /

ROUND((SUM(DECODE(NAME,'FREEMEMORY',BYTES,0))))
-----------------------------------------------
                                      558360344

regards
Hrishy

[ggnanaraj]

select bytes from v$sgastat where name = 'free memory' and pool = 'shared pool';

HTH

[paragp1981]

Thanks Hrishy

[paragp1981]

ggnanaraj,
Thanks man for your quick reply it helped m a lot. but i think query given by hrishy is more specific coz it gives correct free space and your query will give free space only in shared pool. When i queried
select * from v$sgastat;

i noticed...

large pool free memory 16777216
java pool free memory 117440512

they are the part of SGA . But i have not configured them just its a free space . Will it get used if need arises. like increasing any parameter.