Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot find FILE_ID 201 in dba_data_files

DoublethinkSep 2 2010 — edited Sep 2 2010
Hi fellow dba's,

i was investigating performance issue, every hour there is alot of i/o generated by the oracle agent11g:
SYS@ABCD> SELECT p1 "file#", p2 "block#", p3 "class#" FROM v$session_wait WHERE event = 'direct path read temp';

     file#     block#     class#
---------- ---------- ----------
       201    3625790         31

SYS@ABCD>  select file_id,RELATIVE_FNO from dba_data_files;

   FILE_ID RELATIVE_FNO
---------- ------------
         1            1
         2            2
         3         1024
         4         1024
         5         1024
         6         1024
         7         1024
         8         1024
         9         1024
        10         1024
        11         1024
        12         1024
        13         1024
        14         1024
        15         1024
        16         1024
        17         1024
        18         1024
        19         1024
        20         1024
        21         1024
        22         1024
        23         1024
        24         1024
        25         1024
        26         1024
        27         1024
        28         1024
        29         1024
        30         1024
        31         1024
        32         1024
        33         1024
        34         1024
        35         1024
        36         1024

SYS@ABCD> select file_id,RELATIVE_FNO from dba_temp_files;

   FILE_ID RELATIVE_FNO
---------- ------------
         1            1
so the waits are on file_id 201, which i can't find. im a bit lost.

any help is greatly appreciated.
This post has been answered by Taral on Sep 2 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2010
Added on Sep 2 2010
7 comments
2,839 views