Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> direct path read/write wait event
I have oracle 9.2.0.7, running on windows 2003, I find some direct path
read/write wait event, and checked the p1 value of the event is 20.
select * from dba_data_files where file_id=20; 0 rows returned
select FILE#, NAME from V$TEMPFILE;
1 D:\ORACLE\ORADATA\ORA60\TEMP01.DBF I cannot find temp file and data file is 20.
It is very stange
Can you help on this?
Thanks in advance. Received on Wed Nov 16 2005 - 20:15:39 CST