| Function blocking itself [message #684450] |
Wed, 09 June 2021 08:20  |
patdev
Messages: 74
Registered: August 2008
|
Member |
|
|
Hello all,
I have function being called often it has worked well in past. but lately it has been start blocking itself.
i have run following query to check on the block:
select
blocking_session,
sid,
serial#,
wait_class,
seconds_in_wait
from
v$session
where
blocking_session is not NULL
order by
blocking_session;
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
v$lock a,
v$lock b
where
a.block = 1
and
b.request > 0
and
a.id1 = b.id1
and
a.id2 = b.id2;
whenever function calls happens it does show that the same process being blocked by another call of function within same process.
what would be the cause
?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
