|Receive Email for New Articles|
|Which FND_USER is locking that table||| Print ||
|Written by Anil Passi|
|Friday, 09 February 2007|
This is a quick note to share a SQL that will tell you the FND_USER.USER_NAME of the person that has locked a given table in Oracle APPS.
The column named "module" will tell you the name of the Form Function or the Concurrent Program Short name which has aquired a lock onto that table.
,vp.spid AS os_process
FROM fnd_logins fl
WHERE vs.sid = vlocked.session_id
AND vlocked.object_id = c.object_id
AND vs.paddr = vp.addr
AND vp.spid = fl.process_spid(+)
AND vp.pid = fl.pid(+)
AND fl.user_id = fu.user_id(+)
AND c.object_name LIKE '%' || upper('&tab_name_leaveblank4all') || '%'
,'XX') != 'KILLED';
written by Ambati , February 09, 2007
written by srinivasM , September 15, 2007