Re: Reading a file# that doesn't exist
Date: Fri, 16 May 2008 02:59:57 -0400
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.
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