Reading a file# that doesn't exist
Date: Thu, 15 May 2008 17:57:49 -0400
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?
HenryReceived on Thu May 15 2008 - 16:57:49 CDT