oracle 18c health check

1. health check 항목 확인

SELECT name FROM v$hm_check

 

2. health check 수행

BEGIN

      DBMS_HM.run_check ('Dictionary Integrity Check', 'report_dictionary_integrity');

END; /

 

3.  health check 결과 확인

SET LONG 100000

SET LONGCHUNKSIZE 1000

SET PAGESIZE 1000

SET LINESIZE 512

SELECT DBMS_HM.get_run_report ('report_dictionary_integrity') FROM DUAL;