TABLES_SNAP_TIMESTAMP

Updated on 2023-10-31 GMT+08:00

View PDF

TABLES_SNAP_TIMESTAMP records the start and end time of the snapshots created for each performance view. 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.tables_snap_timestamp columns
Name	Type	Description
snapshot_id	name	Snapshot ID. This column is the primary key and distribution key.
db_name	text	Name of the database to which the view belongs
tablename	text	View name
start_ts	timestamp with time zone	Snapshot start time
end_ts	timestamp with time zone	Snapshot end time

NOTICE:

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.

Parent topic: System Catalogs

Previous topic: SNAPSHOT

Next topic: System Catalogs for Performance View Snapshot

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