blocking enq-ss wait events
From: Lok P <loknath.73_at_gmail.com>
Date: Thu, 6 May 2021 09:26:14 +0530
Message-ID: <CAKna9VbJJdz7mGu=LpwmHFvNJEBKGPXJE3R4Q8j_DN04_CnH+Q_at_mail.gmail.com>
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?
Date: Thu, 6 May 2021 09:26:14 +0530
Message-ID: <CAKna9VbJJdz7mGu=LpwmHFvNJEBKGPXJE3R4Q8j_DN04_CnH+Q_at_mail.gmail.com>
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-lReceived on Thu May 06 2021 - 05:56:14 CEST