Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> SNAPSHOT

SNAPSHOT

Updated at: Sep 17, 2021 GMT+08:00

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.

Table 1 dbms_om.snapshot columns

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

  • 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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel