Home » RDBMS Server » Performance Tuning » Function blocking itself (Oracle, 12.1.0.2, Windows)
Function blocking itself [message #684450] Wed, 09 June 2021 08:20 Go to next message
patdev
Messages: 62
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
?




Re: Function blocking itself [message #684451 is a reply to message #684450] Wed, 09 June 2021 10:28 Go to previous message
Michel Cadot
Messages: 67923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Sat, 30 January 2021 07:28

No feedback no help.

Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.
Use SQL*Plus and copy and paste your session, the WHOLE session.

[Updated on: Wed, 09 June 2021 10:28]

Report message to a moderator

Previous Topic: Query running slow
Next Topic: SQL Access Advisor from SQL*Plus
Goto Forum:
  


Current Time: Mon Aug 02 15:48:47 CDT 2021