Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> System Catalogs for Performance View Snapshot

System Catalogs for Performance View Snapshot

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

After enable_wdr_snapshot is set to on, the background snapshot thread creates and maintains a system catalog named in the format of SNAP_View name to record the snapshot result of each performance view. The following system catalogs are accessible only to users with system administrator rights:

Except the new snapshot_id column (of the bigint type), the definitions of the other columns in these system catalogs are the same as those of the corresponding views, and the distribution key of each system catalog is snapshot_id.

For example, SNAP_PGXC_OS_RUN_INFO is used to record snapshots of the PGXC_OS_RUN_INFO view. The snapshot_id column is new, and other columns are the same as those of the PGXC_OS_RUN_INFO view.

  • The schema of all above system catalogs is dbms_om.
  • Do not modify or delete these catalogs 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