前面介绍了Oracle的基本参数,从这节开始讲其他的参数,参数从v$parameter中提取

基本参数请看如下链接:
[http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/)

如无特殊说明数据库版本为11.2

-------

**db_ultra_safe**

[image:343 size:orig]








1. 参数类型:字符串
2. 默认值:OFF
3. 语法:		DB_ULTRA_SAFE = { OFF | DATA_ONLY | DATA_AND_INDEX }
4. 修改:修改需要 重启数据库
6. 基本参数:否



------

**取值意义**

该参数设定其他控制保护级别参数的默认值

**OFF**

- 如果DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, 或 DB_LOST_WRITE_PROTECT已经指定了,则没有改变

**DATA_ONLY**

- DB_BLOCK_CHECKING will be set to MEDIUM.

- DB_LOST_WRITE_PROTECT will be set to TYPICAL.

- DB_BLOCK_CHECKSUM will be set to FULL.


**DATA_AND_INDEX**

- DB_BLOCK_CHECKING will be set to FULL.

- DB_LOST_WRITE_PROTECT will be set to TYPICAL.

- DB_BLOCK_CHECKSUM will be set to FULL.


-------

**更多内容**


[db_block_checksum](http://www.zhaibibei.cn/oralce/oracle-parameter/db_block_checksum/)


--------

**实际截图:**


[image:344 size:orig]







-----

**参考连接**

[https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams067.htm](https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams067.htm)



----------

下期参数

**db_cache_size**