How to Check enq: FB - contention Format Block Enqueue for Insert statements (Doc ID 2277855.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

- Top 5 Timed Foreground Events

- Multiple insert statements on same table which has partition 

- Segment by Read from AWR report shows top % on same insert iable segment ( * indicates Physical, Logical Reads etc)

- Query may use Parallel Executions

- Expected Fractured Blocks because of large object split block

 

Changes

 Recent Changes in Tablespace/Table Level Storage Parameters ( Initrans, Pctfree etc.) 

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