|
-
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.
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
|
Reply With Quote