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.

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.

**Table 1** dbms_om.snapshot columns
Column	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.

Parent Topic: System Catalogs

Previous topic: PLAN_TABLE_DATA

Next topic: TABLES_SNAP_TIMESTAMP

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel