“library cache lock, gc cr request and gc buffer busy acquire” Wait Events After Upgrade to Oracle 12.2

When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the database. At the same time, when users try to login, it can be seen that queries such as the following cause the “library cache lock” wait event.

or

It has been found that there is a query like below which causes login operations to wait. The problem will be solved when session trying to do this update is killed. However, in heavily used databases, “gc cr request and gc buffer busy acquire” wait events make the database unresponsive.

The root cause of the problem is the following bugs. The database patch 25163866 should be applied to solve the problem completely, and if this patch does not resolve, the patch UEK4 kernel 25730857 should be applied. You can apply the patch for the kernel by following the document 2207063.1. To apply the database patch, the database must be closed. When you apply a node on RAC systems, the instance on the node that is applied does not open. Close the database, apply the patch to all nodes, and then open it.

Internal Bug 25163866 – SAGEASM-E DB HANG AT ‘GC CR REQUEST'<=’LIBRARY CACHE LOAD LOCK’
Internal Bug 25730857 – UEK4: Cache Fusion Fails Because of Data Corruption in LWIPC

It is also solved in databases with version 18.1.

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 *