To return all targets under blackout, enter the following query:
SELECT target_name, target_type, start_time, end_time FROM mgmt$blackout_history WHERE sysdate BETWEEN start_time AND NVL(end_time,sysdate+1/60*60*24);
To return all targets under blackout, enter the following query:
SELECT target_name, target_type, start_time, end_time FROM mgmt$blackout_history WHERE sysdate BETWEEN start_time AND NVL(end_time,sysdate+1/60*60*24);