MANUAL segment management on tablespace for AUD$ and FGA_LOG$ could lead to database hanging with gc current request waits (Doc ID 1434614.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms


Example of the chain generated by hanganalyze command level 3.  Note that 11.2, dia0* process will be generated if a hang is detected.  It will include also dump of hanganalyze:

The syntax is for RAC environment, as gc buffer busy acquire wait is RAC specific wait.

Changes

none

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms