-
Free size in SGA
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
Code:
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,
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.
-
select bytes from v$sgastat where name = 'free memory' and pool = 'shared pool';
HTH
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|