DBA_ACTIVITY_SNAPSHOT_META
DBA_ACTIVITY_SNAPSHOT_META displays information about activity snapshots taken by the Object Activity Tracking System (OATS).
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Activity snapshot identifier |
CON_DBNAME |
VARCHAR2(128) |
NOT NULL |
Name of the container to which the data pertains |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Identifier for the instance in which the activity snapshot was taken |
BEGIN_TIME |
TIMESTAMP(3) |
NOT NULL |
Begin time for the activity snapshot interval |
END_TIME |
TIMESTAMP(3) |
NOT NULL |
End time for the activity snapshot interval |
FLUSH_ELAPSED_TIME |
INTERVAL DAY(2) TO SECOND(3) |
Amount of time spent creating the activity snapshot | |
FLUSH_IS_MANUAL |
VARCHAR2(3) |
Indicates whether the activity snapshot was created manually (YES) or not (NO) |