Re: blocking enq-ss wait events

So is it that the killed session which is on "waiting for a undo record" is now blocking all your application queries?

On Thu, May 6, 2021 at 9:26 AM Lok P <loknath.73_at_gmail.com> wrote:

> Hi All, Need some help, we had killed one of the long running sessions
> which was running since ~8hrs+ , but after we kill that we see a lot of
> "wait for a undo record" wait events but we ignored that thinking that will
> run for sometime as because it will do rollback. But suddenly now we are
> seeing "enq-SS contention" wait event in addition to "wait for a undo
> record" and that is blocking all other application queries. So wondering
> how we should mitigate this issue?
>
> The version is 11.2.0.4 of Exadata.
>
> Regards
> Lok
>

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