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

From: Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com>
Date: Tue, 18 Jan 2011 08:53:52 -0600
Message-ID: <C5533BD628A9524496D63801704AE56D68C9A79B65_at_SPOBMEXC14.adprod.directory>

I would assume that is true as well but my data files only go to 205 so that doesn't add up either.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor_at_ingrambarge.com
 
CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

-----Original Message-----
From: Remigiusz Sokolowski [mailto:remigiusz.sokolowski_at_nordea.com] Sent: Tuesday, January 18, 2011 8:48 AM
To: Taylor, Chris David
Cc: oracle-l_at_freelists.org
Subject: Re: V$SESSION_WAIT FILE# Doesn't Exist?

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:53:52 CST