blackouts

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 ;

The MGMT$BLACKOUTS file contains definitions of all blackouts known in the system. To view a list of future scheduled blackouts, enter the following query: SELECT blackout_name, reason, created_by, schedule_type, scheduled_time FROM mgmt$blackouts WHERE status = ‘Scheduled’;