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?
>
> Thanks in advance.

tempfiles start above your max db files setting

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------