If any Concurrent request is slow or takes more than normal time to complete,follow the below steps first to verify ..
HighLevel Steps..
SQL >select * from v$session where process in(select os_process_id from fnd_concurrent_requests where request_id='<Req Id>');
Get SID from above sql.
Take that sid and find object_id's from below command
SQL >select * from v$locked_objects where session_id='SID'
Now take all the object_id's and check any other session is locking those object_ids apart from the above SID...
SQL >select * from v$locked_objects where object_id =''
if any session is locking check the status of that session from v$session.
if that is inactive kill that session ... to free up the resource
SQL >alter system kill session 'SID,SERIAL#';
we can also try gv$locked_object if v$locked_object not showing any output
ReplyDeleteHey Vasanth,
DeleteThanks for your reply .
Sure ,we can try this for more informations related to object levels .