But —they often lead to DG dismounts. 7. Sample Diagnostic Script Save as asm_health_check.sql :

SELECT * FROM V$ASM_HEALTH_CHECKER_HISTORY ORDER BY CHECK_TIME DESC FETCH FIRST 10 ROWS ONLY; SELECT * FROM V$ASM_OPERATION WHERE STATE='FAILED';

PROMPT Pending operations: SELECT * FROM v$asm_operation WHERE state != 'DONE';

PROMPT Recent health check failures: SELECT check_time, failure_count, failure_reason FROM v$asm_health_checker_history WHERE check_time > SYSDATE - 1 ORDER BY check_time DESC;

Health Checker Found 1 New Failures: Asm

But —they often lead to DG dismounts. 7. Sample Diagnostic Script Save as asm_health_check.sql :

SELECT * FROM V$ASM_HEALTH_CHECKER_HISTORY ORDER BY CHECK_TIME DESC FETCH FIRST 10 ROWS ONLY; SELECT * FROM V$ASM_OPERATION WHERE STATE='FAILED';

PROMPT Pending operations: SELECT * FROM v$asm_operation WHERE state != 'DONE';

PROMPT Recent health check failures: SELECT check_time, failure_count, failure_reason FROM v$asm_health_checker_history WHERE check_time > SYSDATE - 1 ORDER BY check_time DESC;