Diagnosing and Resolving enq: SV – Contention Caused by Sequence Usage in Oracle RAC
In an Oracle 11.2.0.4 RAC environment, a spike in database sessions—reaching approximately 80—was observed between 08:45 and 08:55 on December 23. The root cause was traced to the SQL statement:
SELECT TIMEKEYID.NEXTVAL FROM DUAL;
AWR reports from the same hour revealed this query executed over 510,000 times. The associated sequence was define ...
Posted on Mon, 02 Nov 2026 16:31:59 +0000 by papapax