Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> 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






Snapshot ID. This column is the primary key and distribution key.


timestamp with time zone

Snapshot start time


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