[bbk1190]第2集 - Chapter 01-Oracle Architectural

查看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