Managing Snapshot : Creating Snapshots

最新推荐文章于 2025-10-18 14:11:11 发布

转载最新推荐文章于 2025-10-18 14:11:11 发布 · 110 阅读

本文介绍如何使用CREATE_SNAPSHOT过程手动创建实例快照，以便在自动快照生成之外的时间捕获统计信息。通过这种方式，可以更灵活地控制统计信息的收集时间。

You can manually create snapshots with the CREATE_SNAPSHOT procedure if you
want to capture statistics at times different than those of the automatically generated
snapshots. For example:
BEGIN
DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();
END;
/

In this example, a snapshot for the instance is created immediately with the flush level
specified to the default flush level of TYPICAL. You can view this snapshot in the
DBA_HIST_SNAPSHOT view.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1004848/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1004848/