Re: Blocker did not identified

Thanks Jure.
Best Regards.
Eriovaldo

2017-12-31 18:59 GMT-02:00 Jure Bratina <jure.bratina_at_gmail.com>:

> Eriovaldo,
>
> > 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 (
> https://blog.tanelpoder.com/2013/11/06/diagnosing-buffer-
> busy-waits-with-the-ash_wait_chains-sql-script-v0-2/ ).
> 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).
>
> Regards,
> Jure
>
>

--
http://www.freelists.org/webpage/oracle-l