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!

how long a transaction takes to rollback?

591183Nov 24 2007 — edited Nov 24 2007

Hi Folks,

I had a user run a query to delete rows from a large table (32Mill). We DBA's found it and killed it. I have a question in my mind. I wanted to know how long this transaction takes to rollback. i queried the v$rollstat view but couldn't understand any of the columns.

Can you provide me with a sql for finding how long a transaction takes to rollback.

Thanks
Karthik

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2007

Added on Nov 24 2007

#general-database-discussions

9 comments

1,396 views