如何查看oracle中的SGA具體的使用情況

在oracle 11g中提供自動管理的功能memory_target=具體大小G,就不用管了，但是在實際操作還是需要知道某些SGA的大小

SQL*Plus: Release 11.1.0.6.0 - Production on Tue May 5 17:23:14 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
With the Real Application Clusters option

SQL> col name format a20
SQL> select * from v$sgainfo;

NAME BYTES RES
-------------------- ---------- ---
Fixed SGA Size 2147392 No
Redo Buffers 17014784 No
Buffer Cache Size 2818572288 Yes
Shared Pool Size 2013265920 Yes
Large Pool Size 67108864 Yes
Java Pool Size 67108864 Yes
Streams Pool Size 67108864 Yes
Shared IO Pool Size 0 Yes
Granule Size 67108864 No
Maximum SGA Size 1.0689E+10 No
Startup overhead in 603979776 No

NAME BYTES RES
-------------------- ---------- ---
Shared Pool

Free SGA Memory Avai 5637144576
lable


12 rows selected.
SQL> col name format a20
SQL> select * from v$sgainfo;


NAME BYTES RESIZEABL
-------------------- ---------- ---------
Fixed SGA Size 2144824 No
Redo Buffers 7430144 No
Buffer Cache Size 587202560 Yes
Shared Pool Size 553648128 Yes
Large Pool Size 16777216 Yes
Java Pool Size 16777216 Yes
Streams Pool Size 16777216 Yes
Shared IO Pool Size 0 Yes
Granule Size 16777216 No
Maximum SGA Size 1603411968 No
Startup overhead in 67108864 No

NAME BYTES RESIZEABL
-------------------- ---------- ---------
Shared Pool

Free SGA Memory Avai 402653184
lable


12 rows selected.