My Oracle Support Banner

ODA Support - 12.2 RAC Database High "gc cr/current request" 'gc buffer busy acquire' and Locks On Hot Object SELECT SPARE6 FROM USER$ WHERE USER#=:1 After Upgrading from 11.2.0.4 Single Instance (Doc ID 2583711.1)

Last updated on JANUARY 06, 2022

Applies to:

Oracle Database Appliance Software - Version 12.2.1.1.0 to 12.2.1.4.0 Bare Metal [Release 12.2]
Information in this document applies to any platform.

Symptoms

Upgrade to 12.2 and now sessions are hanging and locking requiring manual killing of sessions.
Requires a RAC configuration as Single-Instance does not show the severity of the problem all other things being equal.
The queries and application had worked before an upgrade and / or migration to 12.2.

Wait events include:



Changes

 Upgrade of the Oracle Product using Linux to UEK4 with kernels older than 4.1.12-61.49.1.
  This includes Engineered Systems running UEK4 which are the default in many 12.2 versions of the product line.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.