Already a member?
Sign in
Welcome! This is a website that everyone can build together. It's easy!
Monitor Free Memory in SGA
select POOL, round(bytes/1024/1024,0) FREE_MB
from v$sgastat
where name like '%free memory%';
POOL............FREE_MB
------------ ----------
shared pool.........293
large pool............7
java pool.............8
from v$sgastat
where name like '%free memory%';
POOL............FREE_MB
------------ ----------
shared pool.........293
large pool............7
java pool.............8
Latest page update: made by olapdba
, Apr 17 2008, 12:31 PM EDT
(about this update
About This Update
Edited by olapdba
view changes
- complete history)
view changes
- complete history)
Keyword tags:
None
More Info: links to this page

