oracle 体现结构

来源：互联网发布：linux入门教程 pdf 编辑：程序博客网时间：2024/05/01 02:00

1.查看granule的大小

SQL> select component,granule_size from v$sga_dynamic_components;

COMPONENT                                                        GRANULE_SIZE
---------------------------------------------------------------- ------------
shared pool                                                           4194304
large pool                                                            4194304
java pool                                                             4194304
streams pool                                                          4194304
DEFAULT buffer cache                                                  4194304
KEEP buffer cache                                                     4194304
RECYCLE buffer cache                                                  4194304
DEFAULT 2K buffer cache                                               4194304
DEFAULT 4K buffer cache                                               4194304
DEFAULT 8K buffer cache                                               4194304
DEFAULT 16K buffer cache                                              4194304

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

已选择13行。

2.更改shared_pool的大小

alter system set shared_pool_size=64M;

3.更改DB_cache_size

alter system set db_cache_size=96M.

4.显示参数表结构

SQL> desc v$parameter;
名称是否为空? 类型
----------------------------------------- -------- ----------------------------

NUM                                                NUMBER
NAME                                               VARCHAR2(80)
TYPE                                               NUMBER
VALUE                                              VARCHAR2(512)
DISPLAY_VALUE                                      VARCHAR2(512)
ISDEFAULT                                          VARCHAR2(9)
ISSES_MODIFIABLE                                   VARCHAR2(5)
ISSYS_MODIFIABLE                                   VARCHAR2(9)
ISINSTANCE_MODIFIABLE                              VARCHAR2(5)
ISMODIFIED                                         VARCHAR2(10)
ISADJUSTED                                         VARCHAR2(5)
ISDEPRECATED                                       VARCHAR2(5)
DESCRIPTION                                        VARCHAR2(255)
UPDATE_COMMENT                                     VARCHAR2(255)
HASH                                               NUMBER

5.显示参数名称和数值

SQL>column name format a30;

SQL>column value from a60;

SQL>select name,value from v$parameter;

或者

SQL>show parameter 参数名（可匹配）