Rollback during Crash Recovery
13989Nov 15 2008 — edited Nov 16 2008Hi,
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