I now feel like an Idiot. Apparently the baseline was created back to 10g
and the BD has been migrated / upgraded at-least twice since then.
Thank you Nigel !!
J
On 8 December 2016 at 23:48, Nigel Thomas <nigel.cl.thomas@xxxxxxxxx> wrote:
Jithin
Try including *dbid* in your select, and then add it to drop_baseline
call; maybe the baseline is stored for a non-default dbid.
Regards Nigel
On 8 December 2016 at 18:06, Jithin Sarath <jithinsarath@xxxxxxxxx> wrote:
I have an AWR baseline someone created ages ago. As part of some house
keeping we would like to delete it. But whatever I try it doesn't let
itself be deleted :)
Any thoughts?
SQL> SELECT baseline_id, baseline_name, START_SNAP_ID,
2 TO_CHAR(start_snap_time, 'DD-MON-YYYY HH24:MI') AS
start_snap_time,
3 END_SNAP_ID,
4 TO_CHAR(end_snap_time, 'DD-MON-YYYY HH24:MI') AS end_snap_time
5 FROM dba_hist_baseline
6 WHERE baseline_type = 'STATIC'
7 ORDER BY baseline_id;
BASELINE_ID BASELINE_NAME START_SNAP_ID START_SNAP_TIME
END_SNAP_ID END_SNAP_TIME
----------- ------------------------------ -------------
----------------- ----------- -----------------
1 AABB AWR NOV-DEC 2009 baseline 29953 08-NOV-2009
00:00 30721 10-DEC-2009 00:00
SQL> BEGIN
2 DBMS_WORKLOAD_REPOSITORY.drop_baseline(baseline_name => 'AABB AWR
NOV-DEC 2009 baseline');
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-13526: baseline (AABB AWR NOV-DEC 2009 baseline) does not exist
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 704
ORA-06512: at line 2