查看granule size 的视图V$SGA_DYNAMIC_COMPONENTS

最新推荐文章于 2021-11-16 00:09:15 发布

ciliting2867

最新推荐文章于 2021-11-16 00:09:15 发布

阅读量213

点赞数

文章标签： java

本文展示了通过Oracle数据库的V$SGA_DYNAMIC_COMPONENTS视图查询SGA中各动态组件的当前大小及粒度大小。具体包括Shared Pool、Large Pool等关键组件的详细信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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                        62914560      4194304
large pool                          4194304      4194304
java pool                           4194304      4194304
streams pool                              0      4194304
DEFAULT buffer cache               92274688      4194304
KEEP buffer cache                         0      4194304
RECYCLE buffer cache                      0      4194304
DEFAULT 2K buffer cache                   0      4194304
DEFAULT 4K buffer cache                   0      4194304
DEFAULT 8K buffer cache                   0      4194304
DEFAULT 16K buffer cache                  0      4194304

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

13 rows selected.