OK - so I'd not got round to reading a recent previous post on the same
issue, seems tim= is in hundredths of seconds for 8i. So I got that bit of
the answer. Still pondering on those 'direct path write' waits though.
_
Tim Onions
Head of Oracle Development
Speech
IIRC, 'direct path write' represents writes to temporary segments.
--- Tim Onions [EMAIL PROTECTED] wrote:
OK - so I'd not got round to reading a recent previous post on the
same
issue, seems tim= is in hundredths of seconds for 8i. So I got that
bit of
the answer. Still pondering on those
So, when you look for the segment_type,segment_name,owner in dba_extents,
what do you see for file_id=1026 and block_id's as listed in p2?
On 10/30/2003 09:44:25 AM, Tim Onions wrote:
Gurus
I've applied many of the things I've learnt from this list over the years
and today I tried a 10046
Mladen
As my db_files parameter is set to 1024 then I take it that p1=1026 refers
to temp file #2 confirming what everybody is telling me its sorting to disk.
Thanks for your input, I now understand what it is I should be looking at.
T¬
--
Please see the official ORACLE-L FAQ:
I saw the responses you've got but my response was delayed by the mailing
list for an unknown reason. That is why I stopped responding. You're in
good hands.
On 10/30/2003 04:59:26 PM, Tim Onions wrote:
Mladen
As my db_files parameter is set to 1024 then I take it that p1=1026 refers
to temp
Hi!
NOCACHE LOBs cause direct path writes as well...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 5:59 PM
IIRC, 'direct path write' represents writes to temporary segments.
--- Tim Onions [EMAIL PROTECTED]
