ora

SGAのコンポーネントのサイズ

SQL> select * from v$sgainfo;
NAME                                  BYTES RES




























































































-













































Fixed SGA Size                    xxxxxxxxx No

Redo Buffers                      xxxxxxxxx No

Buffer Cache Size                 xxxxxxxxx Yes

Shared Pool Size                  xxxxxxxxx Yes

Large Pool Size                   xxxxxxxxx Yes

Java Pool Size                    xxxxxxxxx Yes

Streams Pool Size                 xxxxxxxxx Yes

Shared IO Pool Size               xxxxxxxxx Yes

Granule Size                      xxxxxxxxx No

Maximum SGA Size                  xxxxxxxxx No

Startup overhead in Shared Pool   xxxxxxxxx No

Free SGA Memory Available         xxxxxxxxx
12行が選択されました。
SQL>