My guess, subtract the value of db_files, you end up with the file_id in dba_temp_files Waleed -----Original Message----- From: jsb@xxxxxxxxxxxx [mailto:jsb@xxxxxxxxxxxx]=20 Sent: Wednesday, July 21, 2004 11:01 AM To: oracle-l@xxxxxxxxxxxxx Subject: WAIT #1: nam=3D'direct path write' ela=3D 4809 p1=3D202 = p2=3D14480 p3=3D9 - file 202 does not exist! From 10046 trace, one of MANY similar lines: WAIT #1: nam=3D'direct path write' ela=3D 4809 p1=3D202 p2=3D14480 = p3=3D9 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=3D202 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------