DBMS_WORKLOAD_REPOSITORY
This package allows management of Workload Repository.
Procedures
The most relevant procedures are:
CREATE_SNAPSHOT
: creates a manual snapshotMODIFY_SNAPSHOT_SETTINGS
: modifies the snapshot settingsCREATE_BASELINE
: creates a single baseline
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.