The CREATE_SNAPSHOT procedure is used to trigger the generation of a snapshot for a cluster and is only available under the SYS tenant.
Syntax
DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(
flush_level VARCHAR(64) DEFAULT 'TYPICAL'
);
Parameters
| Parameter | Description |
|---|---|
| flush_level | Specifies the snapshot type. Currently, only the TYPICAL snapshot is supported, which is used to collect most statistical data. |
Considerations
After a user manually creates a snapshot, the timer is reset. For example, if the default INTERVAL is 1 hour:
12:21 Timer triggers the creation of a snapshot.
13:21 Timer triggers the creation of the next snapshot.
13:45 User manually creates a snapshot.
14:45 Timer triggers the creation of the next snapshot.
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(flush_level => 'TYPICAL');
Query OK, 0 rows affected