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.
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
Subject: [Toad for Oracle - Discussion Forum] 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.
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