Advertisement

05.13.2008 at 03:27PM PDT, ID: 23399678
[x]
Attachment Details

How to determine if a undo or rollback is complete?

Asked by crxi in Oracle Database, Oracle 10.x

Tags: Oracle, SQL Developer, 10g

I had a bad update query that was taking too long, so I killed it.  Now the undo is taking just as long.  Using SQL Developer or SQL Plus, is there a way, or query to run that will tell me whether the undo is completed, or not?Start Free Trial
 
Keywords: How to determine if a undo or rollback i…
Title
1 Undo Delete/Update
2 Kill Rollback?
3 Can you stop a Rollback?
4 Dropping UNDO tablespace did not free…
5 Delete a rollback segment with undo_…
6 undo fonction
 
Loading Advertisement...
 
[+][-]05.13.2008 at 05:15PM PDT, ID: 21560329

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.13.2008 at 05:17PM PDT, ID: 21560338

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle Database, Oracle 10.x
Tags: Oracle, SQL Developer, 10g
Sign Up Now!
Solution Provided By: aiklamha
Participating Experts: 4
Solution Grade: A
 
 
[+][-]05.13.2008 at 06:31PM PDT, ID: 21560579

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.14.2008 at 12:59AM PDT, ID: 21561936

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]05.14.2008 at 08:31AM PDT, ID: 21565298

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628