Block class seems important here. Hnery, can you post the whole result of v$sesssion_wait including p1, p2 and p3? And if possible, block dump for the problematic block(if not too many) might give some hints. Dion Cho 2008/5/16, Tim Gorman <tim@xxxxxxxxx>: > > There's little reason to do anything except "direct path read/write" to > tempfiles. Think about it -- no need to share with other sessions, so why > involve SGA resources at all? Tempfiles are just an extension to the PGA, > in essence... > > > > Quoting Bradd Piontek <piontekdd@xxxxxxxxx>: > > Would temp files show up as 'direct path read' and 'direct path write' >> waits? >> >> On Thu, May 15, 2008 at 5:03 PM, Tim Gorman <tim@xxxxxxxxx> wrote: >> >> Tempfiles are numbered from (DB_FILES+1) upward... >>> >>> >>> >>> >>> Quoting Henry Poras <henry@xxxxxxxxxxxxxxx>: >>> >>> I have a session on a development system that is waiting on 'db file >>> >>>> sequential read'. >>>> >>>> It has been waiting for ~6000 seconds (state=WAITING). >>>> >>>> File# (p1) is 201, yet the database only has file#'s from 1-19 (select >>>> file# >>>> from v$datafile). >>>> >>>> That explains the long wait. It's trying to read from a non-existent >>>> file. >>>> I >>>> can't connect to strace (attach: ptrace (PTRACE_ATTACH, .): Operation >>>> not >>>> permitted). >>>> >>>> Has anyone seen this before? Any ideas where to look? Just reboot and >>>> try >>>> for the best? >>>> >>>> Henry >>>> >>>> -- >>> //www.freelists.org/webpage/oracle-l >>> >>> >>> >>> >> >> -- >> Bradd Piontek >> Twitter: http://www.twitter.com/piontekdd >> Oracle Blog: http://piontekdd.blogspot.com >> Linked In: http://www.linkedin.com/in/piontekdd >> Last.fm: http://www.last.fm/user/piontekdd/ >> >> > > -- > //www.freelists.org/webpage/oracle-l > > >