Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

db file sequential read on delete

KSGMay 18 2015 — edited May 19 2015

Oracle 11.2.0.3.0 on Linux X86-64

The delete statement was not completing for hours.

When I check, the delete statement (sid 68) was blocked by session id (128). When I check the sid 128 it's showing event as 'db file sequential read' on undo tablespace.

I increased the undo tablespace size. Then the blocking session 128 was showing on 'datafile01.dbf' The datafile01.dbf is 100%fill.

My humble question is why the wait event 'db file sequential read' show on datafiles?

Regards

KSG

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2015

Added on May 18 2015

#general-database-discussions

5 comments

721 views