Re: Blocker did not identified

From: Jure Bratina <>
Date: Sun, 31 Dec 2017 21:59:06 +0100
Message-ID: <>


> I need to improve this query trying to get the main BLOCKER.
> But it does not help in case of similar problem, by the time configured
for dba_hist refresh.

Maybe Tanel's dash_wait_chains.sql might help ( ).
Or, alternatively, ash_wait_chains.sql if the wait is in progress and for some strange reason the BLOCKING_* columns in v$session aren't populated (especially FINAL_BLOCKING_SESSION in your case).


Received on Sun Dec 31 2017 - 21:59:06 CET

Original text of this message