OraFAQ Forum: Performance Tuning » Function blocking itself

Home » RDBMS Server » Performance Tuning » Function blocking itself (Oracle, 12.1.0.2, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Function blocking itself [message #684450]

Wed, 09 June 2021 08:20

patdev
Messages: 77
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
?

Report message to a moderator

Re: Function blocking itself [message #684451 is a reply to message #684450]

Wed, 09 June 2021 10:28

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 09:16:43 CDT 2025