Hi, I will explain How to Drop and Recreate Temp Tablespace in Oracle Database in this article.   I have seen ” enq: SS – contention Wait Event ” wait event of running session. This wait event means, there are some problems in temp tablespace. you can query the enq: SS – contention wait event … Continue reading How to Drop and Recreate Temp Tablespace in Oracle Database