Re: Reading a file# that doesn't exist

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_at_gmail.com>:

> 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_at_evdbt.com> wrote:
>
>> Tempfiles are numbered from (DB_FILES+1) upward...
>>
>>
>>
>>
>> Quoting Henry Poras <henry_at_itasoftware.com>:
>>
>> 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
>>>
>> --
>> http://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/
>

--
http://www.freelists.org/webpage/oracle-l