Re: Reading a file# that doesn't exist
- From: "조동욱" <ukja.dion@xxxxxxxxx>
- To: tim@xxxxxxxxx
- Date: Fri, 16 May 2008 08:54:35 +0900
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@xxxxxxxxx>:
>
> 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@xxxxxxxxx>:
>
> 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@xxxxxxxxx> wrote:
>>
>> Tempfiles are numbered from (DB_FILES+1) upward...
>>>
>>>
>>>
>>>
>>> Quoting Henry Poras <henry@xxxxxxxxxxxxxxx>:
>>>
>>> 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
>>>>
>>>> --
>>> //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/
>>
>>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
