V$SGAINFO&V$SGASTAT





 

V$SGAINFO支持版本:
10g及后续版本
 
作用:
用于查询sga的各个组件大小
 
结果集范例:
SQL> select * from v$sgainfo;
NAME                                  BYTES RES
——————————– ———- —
Fixed SGA Size                      1299040 No
Redo Buffers                         524288 No
Buffer Cache Size                 339738624 Yes
Shared Pool Size                  184549376 Yes
Large Pool Size                     4194304 Yes
Java Pool Size                      4194304 Yes
Streams Pool Size                         0 Yes
Granule Size                        4194304 No
Maximum SGA Size                  536870912 No
Startup overhead in Shared Pool    37748736 No
Free SGA Memory Available                 0
11 rows selected.
 
用例:
1、查询shared pool总大小:
select bytes from v$sgainfo where name='Shared Pool Size';
 
9i替代方案:
使用V$SGASTAT视图,large pool,shared pool,java pool根据pool字段求byes字段的总字节数,其他组件如log buffer(对应V$SGAINFO中的redo buffers)、buffer cache等根据name字段可直接查询其bytes字段:
如查询shared pool总大小:
select sum(bytes) from v$sgastat group by pool having pool='shared pool';
 



Related posts

coded by nessus
, ,
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件