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 09:02:29 -0600
AHHH. I see...you are correct.
V$parameter
db_files=400
That explains the weird file#. I'll note that for future reference.
Thanks!
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:56 AM
To: Taylor, Chris David
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: V$SESSION_WAIT FILE# Doesn't Exist?
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:
