Skip to Main Content

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!

Rollback during Crash Recovery

13989Nov 15 2008 — edited Nov 16 2008
Hi,

last week i had interesting case:
I did a update on a large table and forgot to commit the transaction.
Than i did a shutdown immediate
After restart the database the instance was very very slow.
I tried to find out which table(s) are rolled back with the help of a view...
=> v$lock (nothing)
=> v$session_longops (nothing)
=> v$transaction.used_ublk =1
I couldn“t find a way to foind out which tables are rolled back during crash recovery.
Is there any chance to see what happens here ?

Thanks
Marco
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2008
Added on Nov 15 2008
5 comments
802 views