Skip to Main Content
  • Questions
  • blocked and blocking users at application level

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question.

Asked: April 20, 2016 - 5:36 am UTC

Last updated: April 20, 2016 - 10:19 am UTC

Version: 12.1.3

Viewed 1000+ times

You Asked

Dear Team,

Greeting!

In our environment we have EBS R12.1.3.

Two purchase department users tried to update the same table's row through a form using EBS login and there is no commit, also.There is locked on that row of that table.

So,my question is ,how can i find the blocked and blocking user ?

how to kill that blocking user ?


your help will be appreciated.

Thanks in advance.


Regards.


and Chris said...

If you have access to the database, you can find which sessions are blocking which with:

select ( select username from v$session where sid=a.sid ) blocker, 
       a.sid, ' is blocking ',
       ( select username from v$session where sid=b.sid ) blockee, 
       b.sid
from   gv$lock a, gv$lock b
where  a.block   = 1
and    b.request > 0
and    a.id1     = b.id1
and    a.id2     = b.id2;


For more on database locks, read:

https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:839412906735

http://www.orafaq.com/node/854

I'm not familiar with EBS, so I'm not sure how this relates to users there.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, April 20, 2016 - 8:27 am UTC

thanks for sharing but i knew this already,i wanted to know at ebs level.Anyway thanks for your help.
Chris Saxon
April 20, 2016 - 10:19 am UTC

Sorry, I'm not familiar with it. Maybe someone else will be able to provide a review with a solution.