Re: V$SESSION_WAIT FILE# Doesn't Exist?
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- Date: Tue, 18 Jan 2011 15:55:48 +0100
Taylor, Chris David pisze:
> I would assume that is true as well but my data files only go to 205 so that
> doesn't add up either.
I meant db_files parameter in Your configuration and not a number of
Your files
>
>
>
> 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
>
>
>
--
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
