Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> direct path read/write wait event

direct path read/write wait event

From: <lsllcm_at_gmail.com>
Date: 16 Nov 2005 18:15:39 -0800
Message-ID: <1132193739.016626.77310@g47g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US