-
What is the value of p1 in parallel query wait event?
A trace file from a parallel query indicates a wait event on a write to file# 1509. But there is no datafile or tempfile with that number. What is this p1 and where is it coming from?
WAIT #1: nam='direct path write' ela= 107 p1=1509 p2=368263 p3=127
WAIT #1: nam='direct path write' ela= 109 p1=1509 p2=192517 p3=127
WAIT #1: nam='direct path write' ela= 135 p1=1509 p2=480649 p3=127
WAIT #1: nam='direct path write' ela= 110 p1=1509 p2=480776 p3=127
WAIT #1: nam='direct path write' ela= 116 p1=1509 p2=480903 p3=127
WAIT #1: nam='direct path write' ela= 123 p1=1509 p2=481030 p3=127
-
p1 = 1509 is the temporary tablespace data file.
1509 = (value in db_files parameter in init.ora)+abs.file_number from v$tempfile.
What is the current value you set for db_files?
Example:
show parameter db_files
NAME TYPE VALUE
-------------------- ----------- ------------------------------
db_files integer 900
grep "direct path write" test_ora_1405102.trc
WAIT #1: nam='direct path write' ela= 2236 p1=901 p2=98628 p3=10
WAIT #1: nam='direct path write' ela= 2 p1=901 p2=98638 p3=2
Tamil
Last edited by tamilselvan; 12-08-2005 at 02:53 PM.
-
Thanks Tamil.
db_files is set to 1500 and temp tablespace has 10 temp files and it is trying to write to file number 9.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|