Bug 28023081 - Sessions Hang Due to Waits 'gc current split'/ 'gc index operation' (Doc ID 28023081.8)

Bug 28023081 Sessions Hang Due to Waits 'gc current split'/ 'gc index operation'

This note gives a brief overview of bug 28023081.
The content was last updated on: 20-OCT-2020
Click here for details of each of the sections below.

Affects:

Product (Component) Oracle Server (Rdbms)

Range of versions believed to be affected Versions BELOW 19.1

Versions confirmed as being affected

18.4.0

18.3.0

18.1.0

12.2.0.1 (Base Release)

Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 28023081 is first included in

19.1.0

Database Release Update (DB RU) 18.5.0.0.190115 (Jan 2019)

12.2.0.1.190115 (Jan 2019) Database Jan 2019 Release Update (DB RU)

12.2.0.1.190416 (Apr 2019) Bundle Patch for Windows Platforms

Interim patches may be available for earlier versions - click here to check.

Symptoms:	Related To:
Performance Affected (General) Waits for "gc current split" Waits for "gc index operation"	RAC (Real Application Clusters) / OPS

Description

This bug is only relevant when using Real Application Clusters (RAC)

In a RAC environment the sessions may hang on 'gc current split'/ 'gc index operation'
 
Rediscovery Notes
 
Session hanging on 'gc current split'/ 'gc index operation' cycle, local DLM lock shows repeated message BAST being sent:
 
GCS SHADOW 0x30661c288,256 resp[0x30e6efa18,0x39b6f.23] pkey 0.11.35289 
...
KJBL history 0x84.0x84.0x84.0x84.0x84.0x84.0x84.0x84...
 
Workaround
 
_gc_fast_index_split_wait=0

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:28023081 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article