SQL> select sum(value)/1024/1024/1024 "TOTAL SGA (GB)" from v$sga;
TOTAL SGA (GB)
--------------------------
25.5105934
SQL> select sum(bytes)/1024/1024/1024 " GB" from v$sgastat where name!='free memory';
GB
----------------
14.027292
Happy Learning ...
No comments:
Post a Comment