Re: Reading a file# that doesn't exist

From: 조동욱 <ukja.dion_at_gmail.com>
Date: Fri, 16 May 2008 08:54:35 +0900
Message-ID: <43c2e3d60805151654t361d4d46ya49fee896fb9eb37@mail.gmail.com>


Block class seems important here.

Hnery, can you post the whole result of v$sesssion_wait including p1, p2 and p3?
And if possible, block dump for the problematic block(if not too many) might give some hints.

Dion Cho

2008/5/16, Tim Gorman <tim_at_evdbt.com>:
>
> There's little reason to do anything except "direct path read/write" to
> tempfiles. Think about it -- no need to share with other sessions, so why
> involve SGA resources at all? Tempfiles are just an extension to the PGA,
> in essence...
>
>
>
> Quoting Bradd Piontek <piontekdd_at_gmail.com>:
>
> Would temp files show up as 'direct path read' and 'direct path write'
>> waits?
>>
>> On Thu, May 15, 2008 at 5:03 PM, Tim Gorman <tim_at_evdbt.com> wrote:
>>
>> 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
>>>
>>>
>>>
>>>
>>
>> --
>> Bradd Piontek
>> Twitter: http://www.twitter.com/piontekdd
>> Oracle Blog: http://piontekdd.blogspot.com
>> Linked In: http://www.linkedin.com/in/piontekdd
>> Last.fm: http://www.last.fm/user/piontekdd/
>>
>>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 15 2008 - 18:54:35 CDT

Original text of this message