enq: SS – contention wait event

“enq: SS – contention” wait event may occur in problems with temp tablespace usage in Oracle RAC databases. At the same time, SMON may be preventing the use of temp space by other processes when cleaning large processes.

With the following query, you can detect the operations that have a “enq: SS – contention” wait event.

Solution

Re-create the existing TEMP table space to resolve the problem. You may want to read the article named “How To Recreate Temp Tablespace

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *