The CREATE_SNAPSHOT procedure triggers snapshot generation for a cluster. It is available only in 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 collects 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 snapshot creation
13:21 Timer triggers the next snapshot creation
13:45 User manually creates a snapshot
14:45 Timer triggers the next snapshot creation
Examples
obclient> CALL DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(flush_level => 'TYPICAL');
Query OK, 0 rows affected