 | | | -none- | -none- 2004-07-21 - By -not available-
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|