Oracle 10g 查看granule size 的视图V$SGA_DYNAMIC_COMPONENTS

SQL> desc V$SGA_DYNAMIC_COMPONENTS
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 COMPONENT                                          VARCHAR2(64)
 CURRENT_SIZE                                       NUMBER
 MIN_SIZE                                           NUMBER
 MAX_SIZE                                           NUMBER
 USER_SPECIFIED_SIZE                                NUMBER
 OPER_COUNT                                         NUMBER
 LAST_OPER_TYPE                                     VARCHAR2(13)
 LAST_OPER_MODE                                     VARCHAR2(9)
 LAST_OPER_TIME                                     DATE
 GRANULE_SIZE                                       NUMBER

SQL>  select component,current_size,granule_size from V$SGA_DYNAMIC_COMPONENTS;

COMPONENT                      CURRENT_SIZE GRANULE_SIZE
------------------------------ ------------ ------------
shared pool                       872415232     16777216
large pool                         16777216     16777216
java pool                          16777216     16777216
streams pool                              0     16777216
DEFAULT buffer cache             4194304000     16777216
KEEP buffer cache                         0     16777216
RECYCLE buffer cache                      0     16777216
DEFAULT 2K buffer cache                   0     16777216
DEFAULT 4K buffer cache                   0     16777216
DEFAULT 8K buffer cache                   0     16777216
DEFAULT 16K buffer cache                  0     16777216

COMPONENT                      CURRENT_SIZE GRANULE_SIZE
------------------------------ ------------ ------------
DEFAULT 32K buffer cache                  0     16777216
ASM Buffer Cache                          0     16777216

13 rows selected.