title: ORA-03113 while executing a sql query
body: <p>I have a 400 line sql query which is throwing exception withing 30 seconds</p>
  
  <blockquote>
    <p>ORA-03113: end-of-file on communication channel</p>
  </blockquote>
  
  <p>Below are things to note:  </p>
  
  <ol>
  <li>I have set the timeout as 10 mins</li>
  <li>There is one last condition when removed resolves this error.</li>
  <li>This error came only recently when I analyzed indexes.</li>
  </ol>
  
  <p>The troubling condition is like this:</p>
  
  <pre><code>AND UPPER (someMultiJoin.someColumn) LIKE UPPER ('%90936%')
  </code></pre>
  
  <p>So my assumption is that the query is getting terminated from the server side apparently because its identified as a resource hog.</p>
  
  <p>Is my assumption appropriate ? How should I go about to fix this problem ?</p>
  
  <p><B>EDIT:</B> I tried to get the explain plan of faulty query but the explain plan query also gives me an ORA-03113 error. I understand that my query is not very performant but why should that be a reason for ORA-03113 error. I am trying to run the query from toad and there are no alert log or trace generated, my db version is 
  <B>Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production</B></p>