Data Block Integrity Check BLC_BL_NUM DBKH_PARAM_UB4 块号
Dictionary Integrity Check CHECK_MASK DBKH_PARAM_TEXT ALL 检查掩码
Dictionary Integrity Check TABLE_NAME DBKH_PARAM_TEXT ALL_CORE_TABLES 表名
Redo Integrity Check SCN_TEXT DBKH_PARAM_TEXT 0 最新良好重做的 SCN (如果已知)
Transaction Integrity Check TXN_ID DBKH_PARAM_TEXT 事务处理 ID
Undo Segment Integrity Check USN_NUMBER DBKH_PARAM_TEXT 还原段号
输入参数通过input_params参数以name/value对用分号来分隔进行传递.下面的例子用事务ID作为参数进行事务完整性检查:
DBMS_HM.RUN_CHECK (
check_name => 'Transaction Integrity Check',
run_name => 'my_trans_run',
input_params => 'TXN_ID=8.31.4');
END;
/
PL/SQL procedure successfully completed.