OracleでSGAに関する情報を取得する方法
- SGAに関する初期化パラメータ
SQL> show parameter sga_ NAME TYPE VALUE ------------------------------ ----------- ------- sga_max_size big integer 160M sga_target big integer 160M
- SGAの割り当て情報
SQL> select * from v$sgainfo; NAME BYTES RES -------------------------------- ---------- --- Fixed SGA Size 1247900 No Redo Buffers 2945024 No Buffer Cache Size 79691776 Yes Shared Pool Size 75497472 Yes Large Pool Size 4194304 Yes Java Pool Size 4194304 Yes Streams Pool Size 0 Yes Granule Size 4194304 No Maximum SGA Size 167772160 No Startup overhead in Shared Pool 37748736 No Free SGA Memory Available 0
