2 Blackout Views

This chapter provides a description of each blackout view and its columns. Blackouts permit you to suspend monitoring on one or more targets in order to perform maintenance operations. It contains the following sections:

For examples of how to use views, see Chapter 20, "Examples".

2.1 MGMT$BLACKOUT_HISTORY

The MGMT$BLACKOUT_HISTORY view displays a historical log of changes in the blackout state for a managed target. In addition, the view can be used to generate a list of targets that were in a blackout period for a specific period of time.

Table 2-1 MGMT$BLACKOUT_HISTORY

Column Description

BLACKOUT_NAME

The name of the blackout

CREATED_BY

The Enterprise Manager administrator who created the blackout

BLACKOUT_GUID

The unique global identifier (GUID) for the blackout

START_TIME

Start of the blackout period for the managed target

END_TIME

End of the blackout period for the managed target. If the target is currently in a blackout period, the END_ TIMESTAMP date will be NULL.

TARGET_NAME

Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.

TARGET_TYPE

Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.

STATUS

Current status of the blackout

Status Values:

  • 0: Scheduled

  • 1: Start Processing

  • 2: Start Partial

  • 4: Started

  • 5: Stop Pending

  • 6: Stop Failed

  • 7: Stop Partial

  • 8: Edit Failed

  • 9: Edit Partial

  • 10: Stopped

  • 11: Ended

  • 12: Partial Blackout

  • 13: Modify Pending

Usage Notes

Queries using this view will use an index if they reference the target_name, target_ type, start_timestamp, or end_timestamp.

Typically, blackout history information retrieved using this view will be ordered by target_name, target_type, and start_timestamp.

2.2 MGMT$BLACKOUTS

The MGMT$BLACKOUTS view displays all blackout definition information along with current schedules.

Table 2-2 MGMT$BLACKOUTS

Column Description

BLACKOUT_NAME

The name of the blackout

BLACKOUT_GUID

The unique global identifier (GUID) of the blackout

REASON

Purpose of the blackout. Reasons are chosen from a predefined list by the report owner

DESCRIPTION

Detailed information about the blackout

STATUS

Current status of the blackout

Status Values:

  • 0: Scheduled

  • 1: Start Processing

  • 2: Start Partial

  • 4: Started

  • 5: Stop Pending

  • 6: Stop Failed

  • 7: Stop Partial

  • 8: Edit Failed

  • 9: Edit Partial

  • 10: Stopped

  • 11: Ended

  • 12: Partial Blackout

  • 13: Modify Pending

CREATED_BY

Administrator who created the blackout. CREATED_BY returns SYSTEM as the blackout owner if the blackout was created using the Enterprise Manager Command Line Interface.

LAST_START_TIME

Last time the blackout successfully started

LAST_END_TIME

Last time the blackout successfully ended

SCHEDULED_TIME

Possible values are:

  • 0 - Immediate schedule

  • 1 - Run once at specified time

  • 2 - Run on interval

  • 3 - Run daily

  • 4 - Run on specified days of the week

  • 5 - Run on specified days of the month

  • 6 - Run on specified days of the year

SCHEDULE_START_TIME

Time the blackout is scheduled to start.

SCHEDULE_END_TIME

Time the blackout is scheduled to end

DURATION

Duration of the blackout in minutes