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: ORA-03113 Error

Re: ORA-03113 Error

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Sat, 10 Jan 2004 17:37:55 +0100
Message-ID: <nha000dtbprqe600h55sg12bj1i98d0ceh@4ax.com> 





On 10 Jan 2004 08:11:10 -0800, drak0nian_at_yahoo.com (Paul Drake) wrote:



>try hiking the sort_area_size and see if it completes successfully.

>I used a sort_area_size of 8M, but 1M is a good starting point.




I would for a start recommend the OP to remove the redundant distinct
in his subquery. It is a strange thing (tm) nobody sees that.



--
Sybrand Bakker, Senior Oracle DBA


Received on Sat Jan 10 2004 - 10:37:55 CST












Original text of this message













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