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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DELETE needing more UNDO does not resume after more UNDO has been added

Dear DBA FrankSep 27 2019 — edited Sep 30 2019

Oracle 12.1.0.2

I'm running a DELETE that deletes about 1/3 of the 150M rows of my 63GB table. Of course it generates a lot of UNDO, and my UNDO tablespace runs out of space. While the session (SID 269) thats runs my DELETE is still active, I get a trace file mentioning that UNDO01 has no more space:

pastedImage_1.png

So I add a datafile to UNDO01 (with MAXSIZE 32GB) hoping my DELETE will resume, but nope it does not:

pastedImage_0.png

it remains stuck at the 33.75 percent you see in the image above. So first of all I'd like to know how come my DELETE is not resuming after more UNDO has been added, and second, since my session is still active, how to exit it gracefully!
This post has been answered by Jonathan Lewis on Sep 27 2019
Jump to Answer
Comments
Post Details
Added on Sep 27 2019
#general-database-discussions
2 comments
381 views