|
-
SQL> select name,
2 sgasize/1024/1024 "Allocated (M)",
3 bytes/1024/1024 "Free (K)",
4 round(bytes/sgasize*100, 2) "% Free"
5 from (select sum(bytes) sgasize from sys.v_$sgastat) s, sys.v_$sgastat f
6 where f.name = 'free memory'
7 /
NAME Allocated (M) Free (K) % Free
-------------------------- ------------- ---------- ----------
free memory 1101.26323 186.887745 16.97
free memory 1101.26323 50 4.54
Which one is correct?
Thanks, ST2003
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
|