Re: Reading a file# that doesn't exist

  • From: henry <henry@xxxxxxxxxxxxxxx>
  • 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. 


Henry


Tim Gorman wrote:

Tempfiles are numbered from (DB_FILES+1) upward...



Quoting Henry Poras <henry@xxxxxxxxxxxxxxx>:


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

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




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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2008