Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Ora-30036 unable to extend segment by 8 in undo tablespace 'undotbs'

happy10319Sep 12 2017 — edited Sep 15 2017

Hi,

On 12.1 C Oracle Linux.

Undotbs is 8Gb.

A job runs between 23:45 and 01:00.

On 26 of Aug and 07 of sept we had :

ora-30036 unable to extend segment by 8 in undo tablespace 'undotbs'

Then I query DBA_HIST_UNDOSTAT.

For 7 of sept:

pastedImage_0.png

For 26 of Aug:

pastedImage_3.png

Ok then they were more than 8Gb.

On 5 of september no ora-30036 error even if UNDOBLKS is more than 8Gb

pastedImage_4.png

I can not explain that.

Thanks for your ideas.
This post has been answered by ddf_dba on Sep 14 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2017
Added on Sep 12 2017
#general-database-discussions
13 comments
1,163 views