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.