Re: direct path read/write wait event

lsllcm_at_gmail.com wrote:
> 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?
>

Controlfile(s)?
Redo logs? Received on Wed Nov 16 2005 - 20:36:38 CST