在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.
2009年5月5日星期二
订阅:
博文评论 (Atom)
没有评论:
发表评论