Thursday, November 9, 2017
Running DB Health Check
select name from v$hm_check where internal_check='N';
NAME
DB Structure Integrity Check
CF Block Integrity Check
Data Block Integrity Check
Redo Integrity Check
Transaction Integrity Check
Undo Segment Integrity Check
Dictionary Integrity Check
ASM Allocation Check
begin
dbms_hm.run_check('Dictionary Integrity Check','dict_integ_test');
end;
select dbms_hm.get_run_report('dict_integ_test') from dual;
Basic Run Information
Run Name : dict_integ_test
Run Id : 4031521
Check Name : Dictionary Integrity Check
Mode : MANUAL
Status : COMPLETED
Start Time : 2017-11-09 07:23:24.832618 +03:00
End Time : 2017-11-09 07:23:31.261958 +03:00
Error Encountered : 0
Source Incident Id : 0
Number of Incidents Created : 0
Input Paramters for the Run
TABLE_NAME=ALL_CORE_TABLES
CHECK_MASK=ALL
No comments:
Post a Comment