5.10 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)

Note:

This view is available starting with Oracle Database 21c.