Re: Reading a file# that doesn't exist

From: Tim Gorman <tim_at_evdbt.com>
Date: Thu, 15 May 2008 16:03:14 -0600
Message-ID: <20080515160314.fzgxgbt544oc88gw@webmail.evdbt.com>


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 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-l
Received on Thu May 15 2008 - 17:03:14 CDT

Original text of this message