What are the maximum files for the DB set to? 200? If so, this ought to be your second tempfile. I have seen that in other pleces, not completely sure it is how it works in the 10046 report. Mathias On Thu, May 7, 2009 at 7:37 PM, Schauss, R. Peter (IT Solutions) < peter.schauss@xxxxxxx> wrote: > This is Oracle 8.1.7.4. > > I am attempting to interpret a 10046 trace, looking at a line that says: > > WAIT #1: nam='direct path read' ela= 0 p1=202 p2=955893 p3=16 > > As I understand it, p1 is the file number and p2 is the block number, > but my database does not have a file number 202. What am I missing > here? > > Thanks, > Peter Schauss > -- > //www.freelists.org/webpage/oracle-l > > >