Database Administration (MOSC)

MOSC Banner

Large undo due to droping task AUTO_STATS_ADVISOR_TASK

edited Jan 9, 2020 2:17PM in Database Administration (MOSC) 11 commentsAnswered ✓

Hello,

I just followed steps in  (Doc ID 2305512.1) and executed

DECLARE
v_tname VARCHAR2(32767);
BEGIN
v_tname := 'AUTO_STATS_ADVISOR_TASK';
DBMS_STATS.DROP_ADVISOR_TASK(v_tname);
END;
/

This caused big growth of Undo TBS so I canceled job by clicking Ctrl-C. Now I see that undo consumption was not cleaned up after breaking job (but stopped growing). Should I clean now undo manually or it will be cleaned by Oracle if needed ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center