Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tempspace usage

Re: tempspace usage

From: JTommaney <cdos_jtommaney_at_comcast.net>
Date: 5 Oct 2005 18:16:28 -0700
Message-ID: <1128561388.480421.166870@f14g2000cwb.googlegroups.com> 





I would trace both executions and see what actually is happening.



One possibility is that SQL run within pl/sql is run with an
optimizer_mode = 'all_rows' .  The assumption there is that no rows
will be returned until completion of the pl/sql anyway.



You would probably need to provide the trace information and the actual
sql to get additional analysis, though.
Received on Wed Oct 05 2005 - 20:16:28 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US