Re: V$SESSION_WAIT FILE# Doesn't Exist?

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 18 Jan 2011 15:47:42 +0100
Message-ID: <4D35A80E.1060902_at_nordea.com>

Taylor, Chris David pisze:
> Ok, I've got a "runaway session" in my PeopleSoft database that's been processing since last night.
>
> I have just now started working on this and I wanted to get some input:
>
> SELECT p1 file#, p2 block#, p3 class#
> FROM v$session_wait
> WHERE event = 'direct path read temp'
> ;
>
> File# Block# Class#
> 402 862533 15
>
> SELECT relative_fno, owner, segment_name, segment_type
> FROM dba_extents
> WHERE file_id = 402
> --AND &block BETWEEN block_id AND block_id + &block - 1;
>
> NO ROWS FOUND
>
> What??
>
> If I look at both V$DATAFILE and V$TEMPFILE I have no File# = 402 so what is going on?
>
> Like I said, I just started working on this so I may be missing something simple...
>
>

I suppose this is the temporary file with id 2 - AFAIK they are counted as db_files+temporary_file_id or so

Regards
Remigiusz

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77

Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem: 0000021828, 
dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku, 
VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego, 
o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych, 
NIP: 586-000-78-20, REGON: 190024711
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 18 2011 - 08:47:42 CST