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
Printable View
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
Hi
regardsCode: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
Hrishy
select bytes from v$sgastat where name = 'free memory' and pool = 'shared pool';
HTH
Thanks Hrishy
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.