RE: WAIT #1: nam='direct path write' ela= 4809 p1=202 p2=14480 p3=9 - file 202 does not exist!

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Wed, 21 Jul 2004 13:12:28 -0400
Message-ID: <E1732F21A9B99440B2117A3BEC76B91D01420F@ztangousexch.ad.ztango.com>

Yes, for tempfile you need to substract it from db_files. So if your db_files is 200, your tempfile starts at 201. Richard Ji

-----Original Message-----

From:	jsb_at_digistar.com [mailto:jsb_at_digistar.com]
Sent:	Wed 7/21/2004 11:01 AM
To:	oracle-l_at_freelists.org
Cc:	
Subject:	WAIT #1: nam='direct path write' ela= 4809 p1=202 p2=14480 p3=9 - file 202 does not exist!

>From 10046 trace, one of MANY similar lines:

WAIT #1: nam='direct path write' ela= 4809 p1=202 p2=14480 p3=9

The trace file says i'm beating up file# 202 yet I do not have a file# 202 - not there in v$tempfile nor v$datafile. I know that I have a lot of disk sorting going on by digging into the explain plan.

But I need to know how to match p1=202 to TEMP for The Boss(tm). Does the value of p1 get transformed somehow?

Does the explain plan temp space report the number of db_block_size blocks or the number of bytes allocated for the sort?

select file# from v$tempfile

SQL> select file# from v$tempfile;

     FILE#

---

         1
         2

SQL> select file# from v$datafile;

     FILE#

---

         1
         2
         3
         4
         5
         6
         7
         8
         9
        10
        11
        12
        13
        14
        15
        16
        17
        18
        19
        20


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------




-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 21 2004 - 12:09:37 CDT