Database Administration (MOSC)

MOSC Banner

ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'

edited Jan 28, 2026 4:11AM in Database Administration (MOSC) 5 commentsAnswered

Hi Team,

We are purging stats using the below procedure as part of applying timezone upgrade.

SQL> select count(*) from SYS.WRI$_OPTSTAT_HISTGRM_HISTORY;

COUNT(*)

23585522

select count(*) from SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY;

COUNT(*)

32907064

SQL> exec DBMS_STATS.PURGE_STATS(systimestamp);
*
ERROR at line 1:
ORA-30036: unable to extend segment by 8 in undo tablespace 'APPS_UNDOTS1'
ORA-06512: at "SYS.DBMS_STATS", line 47863
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 193
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 12212
ORA-06512: at "SYS.DBMS_STATS", line 47850
ORA-06512: at "SYS.DBMS_STATS", line 47876
ORA-06512: at line 1

SQL>select count(*) from SYS.WRI$_OPTSTAT_HISTGRM_HISTORY;

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