RE: Interpreting a direct path read wait

From: Schauss, R. Peter (IT Solutions) <"Schauss,>
Date: Thu, 7 May 2009 13:59:06 -0500
Message-ID: <CD9150D80CFCFB42BC73C40791C1E01903144603_at_XMBIL112.northgrum.com>

That makes sense. Maximum files are set at 200 and file# 2 in v$tempfiles corresponds to the temporary tablespace that the application uses.  

Thanks,
Peter Schauss

---

From: mathiasmag_at_gmail.com [mailto:mathiasmag_at_gmail.com] On Behalf Of Mathias Magnusson
Sent: Thursday, May 07, 2009 2:18 PM
To: Schauss, R. Peter (IT Solutions)
Cc: oracle-l_at_freelists.org
Subject: Re: Interpreting a direct path read wait

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_at_ngc.com> 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
	--
	http://www.freelists.org/webpage/oracle-l
	
	
	

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 07 2009 - 13:59:06 CDT