Skip to content
June 5, 2012 / doganay

ORA-30036: unable to extend segment by string in undo tablespace “string”

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


Problem:

ORA-30036: unable to extend segment by string in undo tablespace "string"

  • On oracle 11.1.0.7, automatic undo management is not stable. Can not expire unused undo blocks every time.


Solution:

alter system set _undo_autotune=FALSE scope=both;
alter system set undo_retention=3600 scope both;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: