Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- This is not a deadlock!
- SAMPLE_ID SESSION_ID BLOCKING_SESSION EVENT P1TEXT P1 P2TEXT P2
- 195514671 3537 1433 read by other session file# 229 block# 936213
- 195514671 1433 3537 read by other session file# 427 block# 2030040
- sid 3537 ash blocking_session is 1433
- sid 1433 ash blocking_session is 3537
- select
- ash.sample_id, ash.session_id, ash.blocking_session, ash.event, ash.p1text, ash.p1, ash.p2text, ash.p2
- from
- gv$active_session_history
- ash
- where ash.sample_id = 195514671
- and ash.session_id in ( 3537, 1433 )
- order by
- ash.blocking_session
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement