前面介绍了Oracle的基本参数,从这节开始讲其他的参数,参数从v$parameter中提取
基本参数请看如下链接: http://www.zhaibibei.cn/oralce/oracle-parameter/
如无特殊说明数据库版本为11.2
db_ultra_safe
取值意义
该参数设定其他控制保护级别参数的默认值
OFF
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.
更多内容
实际截图:
参考连接
https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams067.htm
下期参数
db_cache_size