Advertisement
ExaGridDba

This is not a deadlock!

Jan 29th, 2015
277
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. This is not a deadlock!
  2.  
  3. SAMPLE_ID SESSION_ID BLOCKING_SESSION EVENT P1TEXT P1 P2TEXT P2
  4. 195514671 3537 1433 read by other session file# 229 block# 936213
  5. 195514671 1433 3537 read by other session file# 427 block# 2030040
  6.  
  7. sid 3537 ash blocking_session is 1433
  8.  
  9. sid 1433 ash blocking_session is 3537
  10.  
  11. select
  12. ash.sample_id, ash.session_id, ash.blocking_session, ash.event, ash.p1text, ash.p1, ash.p2text, ash.p2
  13. from
  14. gv$active_session_history
  15. ash
  16. where ash.sample_id = 195514671
  17. and ash.session_id in ( 3537, 1433 )
  18. order by
  19. ash.blocking_session
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement