Reading a file# that doesn't exist

From: Henry Poras <>
Date: Thu, 15 May 2008 17:57:49 -0400
Message-ID: <014501c8b6d6$b7f5e060$>

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. I can't connect to strace (attach: ptrace (PTRACE_ATTACH, .): Operation not permitted).

Has anyone seen this before? Any ideas where to look? Just reboot and try for the best?


Received on Thu May 15 2008 - 16:57:49 CDT

Original text of this message