查看数据库实际使用多大内存

SQL> select sum(value)/1024/1024/1024 as Gb  from v$sga ;

        GB
----------
1.07330322

SQL>
SQL>
SQL> select sum（pga_alloc_mem）/1024/1024/1024 Gb_Alloc from v$process ;

  GB_ALLOC
----------
.255467212

SQL>

　　

转载于:https://www.cnblogs.com/hanglinux/p/8902889.html