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!

need fix for db file sequential read

902332Jan 9 2014 — edited Jan 9 2014

Hi all,

My db is 10.2.0.3.0 on windows. One of our query is very slow. When I checked for the reason from v$session the wait event is db file sequential read. Generated ash report and checked. Report listed one file id(p1), block id(p2), and number of blocks -1(p3). And other objects in the top objects. So how u can fix this now. Does I need to pin the block in the buffer cache..? Or does I need to to pin that complete object. Please suggest. I need to fix this.

Thanks a lot..

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2014

Added on Jan 9 2014

#general-database-discussions

4 comments

335 views