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@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 21 Jul 2004 13:12:28 -0400
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@xxxxxxxxxxxx [mailto:jsb@xxxxxxxxxxxx]
Sent: Wed 7/21/2004 11:01 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
