DB_ULTRA_SAFE

Property	Description
Parameter type	String
Syntax	DB_ULTRA_SAFE = { OFF | DATA_ONLY | DATA_AND_INDEX }
Default value	OFF
Modifiable	No
Basic	No

DB_ULTRA_SAFE sets the default values for other parameters that control protection levels.

Values:

· OFF

When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.

· DATA_ONLY

o DB_BLOCK_CHECKING will be set to MEDIUM.

o DB_LOST_WRITE_PROTECT will be set to TYPICAL.

o DB_BLOCK_CHECKSUM will be set to FULL.

· DATA_AND_INDEX

o DB_BLOCK_CHECKING will be set to FULL.

o DB_LOST_WRITE_PROTECT will be set to TYPICAL.

o DB_BLOCK_CHECKSUM will be set to FULL.

Note:

1. This parameter was introduced in 11g.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) = ‘DB_ULTRA_SAFE’;

Oracle initializatoin parameters