SNAPSHOT¶
SNAPSHOT records the start and end time of each performance view snapshot creation. After enable_wdr_snapshot is set to on, this catalog is created and maintained by the background snapshot thread. It is accessible only to users with system administrator rights.
Name | Type | Description |
|---|---|---|
snapshot_id | name | Snapshot ID. This column is the primary key and distribution key. |
start_ts | timestamp with time zone | Snapshot start time |
end_ts | timestamp with time zone | Snapshot end time |
Important
This system catalog's schema is dbms_om.
Do not modify or delete this catalog externally. Otherwise, functions related to view snapshots may not work properly.