RE: V$SESSION_WAIT FILE# Doesn't Exist?
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: 'Remigiusz Sokolowski' <remigiusz.sokolowski@xxxxxxxxxx>
- Date: Tue, 18 Jan 2011 08:53:52 -0600
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@xxxxxxxxxxxxxxx
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@xxxxxxxxxx]
Sent: Tuesday, January 18, 2011 8:48 AM
To: Taylor, Chris David
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
