HI,
I our production database we observed blocker session, when i check what is the blocker session of query is an update statemen.
as per confirmation from application team, i killed that sqlid, but after few minutes when i check lock session ,it is appearing the same sqlid of blocker session. How it is possible to get the same sqlid of blocker seesion?
next blocker session of sqlid keep on changing,but some blocker session of sqlid of query is “select statement”
is it possible select statement will block the session.?
- after killing the blocker session, why it is comming again with different sid,serial#
please clarify the my doubt