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 Examples.
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:
|
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.
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:
|
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:
|
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 |