Enq: SS Contention

Hello Everyone -

Oracle RAC 11.2.0.3 on OEL 5.x

Recently we had a meltdown of our production environment with "Enq: SS Contention" wait event. I noticed a blocking session responsible for most of the damage. With ASH report I am able to identify the blocking session ID, Serial#, instance etc.

However when I query the v$active_session_history, I don't see corresponding session. Is there a way to find out this information? I am interested in finding out the historical v$session info like client_info, module, program, osuser etc. This issue happened on 9/4, so I still have the ASH data, but not for long.

It would be great if you could suggest any way to find out this..

Second part of the question is, I know the contention is related to Temp tablespace based on the values from p1, p2, p3. What might cause SS enqueue contention? How could I reduce the possibility of having one in future? FYI, I already have 1 tempfile/per each Oracle RAC node.

Thanks in advance
-Upendra
--

http://www.freelists.org/webpage/oracle-l Received on Sun Sep 06 2015 - 11:13:38 CEST