Database Administration (MOSC)

MOSC Banner

how to find the session details of a killed transaction that is being rolled back

edited Sep 29, 2016 5:01AM in Database Administration (MOSC) 3 commentsAnswered

how to find the  session details of a killed transaction that is being rolled back

We see that some session was killed and it triggered rollback

we used below query

select usn, inst_id,state, undoblockstotal "Total", undoblocksdone "Done", undoblockstotal-undoblocksdone "ToDo",

    decode(cputime,0,'unknown',sysdate+(((undoblockstotal-undoblocksdone) / (undoblocksdone / cputime)) / 86400)) "Estimated time to complete"

    from gv$fast_start_transactions;

We want to identify which sid was running at the time of termination

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center