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 filesequential 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