Toad World® Forums

undo tablespace


#1

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.


#2

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]

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

To: toadoracle@toadworld.com

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

undo tablespace

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 on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#3

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