The CREATE_SNAPSHOT procedure triggers the generation of a snapshot 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 type of snapshot. Currently, only the TYPICAL snapshot is supported. TYPICAL snapshots are 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 The timer triggers the creation of a snapshot.
13:21 The timer triggers the creation of the next snapshot.
13:45 A 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