The CREATE_SNAPSHOT procedure is used to trigger snapshot generation for a cluster and is available only in the SYS tenant.
Syntax
DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(
flush_level VARCHAR(64) DEFAULT 'TYPICAL'
);
Parameters
Parameter |
Note |
|---|---|
| flush_level | Specifies the snapshot type. Currently, only the regular snapshot type TYPICAL is supported, which collects most statistics. |
Usage instructions
After you manually create a snapshot, the timer restarts. For example, with the default INTERVAL of 1 hour:
12:21 Trigger snapshot creation by timer
13:21 The timer triggers the creation of the next snapshot.
13:45 User manually creates a snapshot.
14:45 The timer triggers the creation of the next snapshot.
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(flush_level => 'TYPICAL');
Query OK, 0 rows affected