Re: Reading a file# that doesn't exist

Why not give us the output of this as well:

select file#,tablespace_name from dba_data_files UNION
select file#,tablespace_name from dba_temp_files order by file#;

On Fri, May 16, 2008 at 1:59 AM, henry <henry_at_itasoftware.com> wrote:

> I thought the same thing at first, but I've only got one tempfile in this
> system. It doesn't get me anywhere close to 201.
>
> Henry
>
>
> Tim Gorman 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.
>>>
>>>
>>> Henry
>>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
> --
> 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