1.当前数据库的内存池使用明细

set echo off
set feedback off
set timing off
set verify off
set lineshow off
set pagesize 1000


select NAME,
       trunc(sum(TOTAL_SIZE)/1024/1024) as TOTAL_SIZE_MB, 
       trunc(sum(RESERVED_SIZE/1024/1024)) AS RESERVED_SIZE_MB 
from v$mem_pool 
group by NAME 
order by 2;

2.当前数据库的BUFFER使用明细

select NAME,
       trunc(sum(PAGE_SIZE*N_PAGES)/1024/1024)  as TOTAL_SIZE_MB 
from V$BUFFERPOOL 
group by NAME 
order by 2;

3.当前数据库的BUFF使用buffer

select trunc(sum(n_pages*page_size)/1024.0/1024) as TOTAL_SIZE_MB from v$bufferpool;