Interpreting a direct path read wait

From: Schauss, R. Peter (IT Solutions) <"Schauss,>
Date: Thu, 7 May 2009 12:37:53 -0500
Message-ID: <>

This is Oracle

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?

Peter Schauss

Received on Thu May 07 2009 - 12:37:53 CDT

Original text of this message