RE: Reading a file# that doesn't exist

DB_FILES, the init parameter, not the number of data files you currently have. That's so you can't bump into it by dynamically adding permanent files during a run of a given instance.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of henry
Sent: Friday, May 16, 2008 3:00 AM
Cc: oracle-l_at_freelists.org
Subject: Re: Reading a file# that doesn't exist

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




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