Re: Interpreting a direct path read wait

From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Thu, 7 May 2009 20:17:31 +0200
Message-ID: <8580d4110905071117l77f62d0bn34485d4ee563373e_at_mail.gmail.com>

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:17:31 CDT