Reading a file# that doesn't exist
From: Henry Poras <henry_at_itasoftware.com>
Date: Thu, 15 May 2008 17:57:49 -0400
Message-ID: <014501c8b6d6$b7f5e060$8b00040a@itasoftware.com>
Date: Thu, 15 May 2008 17:57:49 -0400
Message-ID: <014501c8b6d6$b7f5e060$8b00040a@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. 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?
Henry
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 15 2008 - 16:57:49 CDT