# undo tablespace

**URL:** <https://forums.toadworld.com/t/undo-tablespace/27231>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 19, 2013, 4:21pm UTC](https://forums.toadworld.com/t/undo-tablespace/27231 "2013-10-19T16:21:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mark.murray](https://avatars.discourse-cdn.com/v4/letter/m/d07c76/32.png) [@mark.murray](https://forums.toadworld.com/u/mark.murray)\
**Post date:** [October 19, 2013, 4:21pm UTC](https://forums.toadworld.com/t/undo-tablespace/27231/1 "2013-10-19T16:21:24Z")

</div>

After cancelling a dml statement via ctl-c in an sqlplus window, a dba wonders if there is a reason be concerned about the undo tablespace since it it now 50% full.

The toad advisor says there is no problem with the undo tablespace.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 21, 2013, 6:21am UTC](https://forums.toadworld.com/t/undo-tablespace/27231/2 "2013-10-21T06:21:59Z")

</div>

Hi Mark,

I am not sure if you are reporting this as a problem, but if so, all I can say is that this information comes from Oracle’s dbms\_undo\_adv package. Toad is  
only the messenger. And we all know that you aren’t supposed to shoot the messenger.

-John

**From:** mark.murray [[mailto:bounce-markmurray@toadworld.com](mailto:bounce-markmurray@toadworld.com)]

**Sent:** Saturday, October 19, 2013 6:22 PM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** [Toad for Oracle - Discussion Forum] undo tablespace

**[undo tablespace](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20563.aspx)**

Thread created by mark.murray

After cancelling a dml statement via ctl-c in an sqlplus window, a dba wonders if there is a reason be concerned about the undo tablespace since it it now 50%  
full.

The toad advisor says there is no problem with the undo tablespace.

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20563.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/t/20563.aspx?AbuseContentId=e16e1676-86ac-477c-b2f3-9f32feec7312&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/f3b0b1d0/5hkvSo.gif)

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [October 22, 2013, 12:02am UTC](https://forums.toadworld.com/t/undo-tablespace/27231/3 "2013-10-22T00:02:43Z")

</div>

> After cancelling a dml statement via ctl-c in an sqlplus window

In that time, UNDO is already filled with all transaction data. So size from that moment can only become smaller because data is starting to return to datafiles.

Brg

Damir Vadas