Skip to Main Content

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 the undo files.

zigiApr 24 2012 — edited Apr 29 2013
Hi
OS : AIX 5.3
Oracle :11.2.0.3

Way when running an update on all table (full scan) I have many "db file sequential read" event.

My tables without index on it.

Most of the "db file sequential read" is on the undo files.

I am the only session on the DB.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 27 2013
Added on Apr 24 2012
8 comments
1,085 views