查看SGA参数信息
SQL> show sga; Total System Global Area 3256942592 bytes Fixed Size 2217752 bytes Variable Size 1795164392 bytes Database Buffers 1442840576 bytes Redo Buffers 16719872 bytes SQL> show parameter SGA_MAX NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 3120M
查看granule size
SQL> select component,granule_size from v$sga_dynamic_components; COMPONENT GRANULE_SIZE ---------------------------------------------------------------- ------------ shared pool 16777216 large pool 16777216 java pool 16777216 streams pool 16777216 DEFAULT buffer cache 16777216 KEEP buffer cache 16777216 RECYCLE buffer cache 16777216 DEFAULT 2K buffer cache 16777216 DEFAULT 4K buffer cache 16777216 DEFAULT 8K buffer cache 16777216 DEFAULT 16K buffer cache 16777216 COMPONENT GRANULE_SIZE ---------------------------------------------------------------- ------------ DEFAULT 32K buffer cache 16777216 Shared IO Pool 16777216 ASM Buffer Cache 16777216 14 rows selected.
查看memory_target
SQL> show parameter memory_target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ memory_target big integer 3120M