查看数据库实际使用多大内存
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>
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>