RE: 10046 level 8 trace - help required with 'direct path write'

From: Tim Onions <tim.onions_at_speechmachines.com>
Date: Thu, 30 Oct 2003 13:59:26 -0800
Message-ID: <F001.005D51AF.20031030135926@fatcity.com>

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: http://www.orafaq.net
--

Author: Tim Onions
  INET: tim.onions_at_speechmachines.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Oct 30 2003 - 15:59:26 CST