How can I view the number of targets blacked out in the last 30 days?

The MGMT$BLACKOUT_HISTORY file contains an overview of all finished blackouts for each target. To view the number of targets blacked out in the last 30 days, enter the following query:

  SELECT target_type, COUNT (*) cnt
    FROM mgmt$blackout_history
   WHERE start_time > SYSDATE - 30
GROUP BY target_type ;