“enq: SQ – contention” Waits and Solution

 

When a sequence is queried, the NEXTVAL value is generated from the seq$ table if it is not cached. If it is cacheed, it will be retrieved from memory.

When the sequences with low cache value are queried too much, “enq: SQ – contention” will occur. To solve this problem, you can increase the cache values of the corresponding sequences.

You can change the cache value of Sequence as follows:

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 *