My Oracle Support Banner

DML HAS MUCH 'DB FILE SEQUENTIAL READ' ON UNDO BLOCK WHILE FLASHBACK DATABASE ON (Doc ID 2421970.1)

Last updated on AUGUST 06, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Application is loading data, about 2M rows, by inserting into a partitioned table. Table has a PK constraint with no additional indexes.

Flashback database is on

TOP Wait event

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
enq: IV - contention 17 0.00 0.01
library cache pin 1 0.00 0.00
row cache lock 11 0.00 0.00
db file sequential read 615948 0.04 525.76 -------------> Top wait event "db file sequential read"

 

 

 

10046 trace

 

Changes

 FLASHBACK logging is ENABLED

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


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