Free Memory Available in Shared Pool, Java Pool, Large Pool and Streams Pool
Sql > select pool, name, bytes/1024/1024 MB
from v$sgastat
where name='free memory';
Free Memory Available in Shared pool :
Sql> select pool, name, bytes/1024/1024 MB
from v$sgastat
where name='free memory' and POOL='shared pool';
Total Memory of shared Pool :
Sql > Show parameter shared_pool
how to calculate free space from database if different mount points are there
ReplyDeleteyou can query dba_free_space and dba_data_files
ReplyDelete