达梦练习-日常维护

修改参数

达梦有4类参数, (v$parameter)

• alter session 动态修改当前session的值.(SESSION)
• alter system 动态修改系统的值, (SYS)
• alter system修改参数文件, 需要重启生效; (IN FILE)
• 只能手动修改参数文件,重启生效 (READ ONLY)

select distinct type from v$parameter;

查看

select name,type, value, sys_value, file_value,default_value from v$parameter where name = 'SORT_BUF_SIZE';

value: 当前session的值
sys_value:系统的值
file_value: 参数文件的值
当alter session 修改当前session的值时, value 与sys_value不同.

修改session/sys

SQL> l
1  select * from v$parameter where name = 'SORT_BUF_SIZE';
SQL> /

LINEID     ID          NAME          TYPE    VALUE SYS_VALUE FILE_VALUE DESCRIPTION                           DEFAULT_VALUE ISDEFAULT
---------- ----------- ------------- ------- ----- --------- ---------- ------------------------------------- ------------- -----------
1          38          SORT_BUF_SIZE SESSION 20    20        20         maximum sort buffer size in Megabytes 20            1

used time: 3.525(ms). Execute id is 56406.
SQL> alter session set 'sort_buf_size'=22;
DMSQL executed successfully
used time: 0.360(ms). Execute id is 56407.
SQL> select * from v$parameter where name = 'SORT_BUF_SIZE';
--修改当前session的值 
LINEID     ID          NAME          TYPE    VALUE SYS_VALUE FILE_VALUE DESCRIPTION                           DEFAULT_VALUE ISDEFAULT
---------- ----------- ------------- ------- ----- --------- ---------- ------------------------------------- ------------- -----------
1          38          SORT_BUF_SIZE SESSION 22    20        20         maximum sort buffer size in Megabytes 20            1

SQL> alter system set 'sort_buf_size'=30;
DMSQL executed successfully
used time: 2.510(ms). Execute id is 56409.
SQL> select * from v$parameter where name = 'SORT_BUF_SIZE';

LINEID     ID          NAME          TYPE    VALUE SYS_VALUE FILE_VALUE DESCRIPTION                           DEFAULT_VALUE ISDEFAULT
---------- ----------- ------------- ------- ----- --------- ---------- ------------------------------------- ------------- -----------
1          38          SORT_BUF_SIZE SESSION 30    30        20         maximum sort buffer size in Megabytes 20            1

used time: 4.349(ms). Execute id is 56410.
SQL>