Re: Reading a file# that doesn't exist

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