When I create an AWR Report, the following error occurs:
Cause: An attempt was made to perform operation with an invalid Start/End Snapshot Pair.
What does this mean, and what should I do about it?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
BEGIN DBMS_WORKLOAD_REPOSITORY.create_baseline ( start_snap_id => --ANY Integer Number_Min Value, end_snap_id => --ANY Integer Number_Max value, , baseline_name => 'batch baseline'); END; /
So here min and max value are already in
DBA_HIST_BASELINE view. You can't chose random value for snapshot.
Remember value already in oracle system, you can't drop value but not overbound.