Re: Reading a file# that doesn't exist

In SQL*Plus, run the command "show parameter db_files" which will show you that the initialization parameter DB_FILES is set to 200, so your first tempfile is numbered 201.

If you were to add another tempfile, it will be numbered 202. And so on...                                                                                                                                                                                                                                                                                                                    

henry 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