vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0636.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

4.0 KiB
Raw Permalink Blame History

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.

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.
Parent topic: System Catalogs