Sunday, December 6, 2015

Manually creating a snapshot

Manually creating a snapshot
You can of course create a snapshot manually by executing:

exec dbms_workload_repository.create_snapshot;

No comments:

Post a Comment

How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g/12c

1. Create Temporary Tablespace Temp create temporary tablespace temp2 tempfile '/mnt/mnt04/oradata/temp01.dbf'size 2000M;  2. Move D...