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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: same sql, same execution plan, but the time to complete is very different when run in different time.

Re: same sql, same execution plan, but the time to complete is very different when run in different time.

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 12 Nov 2007 07:59:28 -0500
Message-ID: <BAY141-DAV3DD3368FE462CC08007B4A6870@phx.gbl> 





Any way you can change your loop through a cursor to single sql. Looks like 
you're looping. Or even bulk load. Even if you find your problem it still 
won't scale. What about your commits, where are they?


----- Original Message ----- 



From: qihua wu


To: oracle-l


Sent: Saturday, November 10, 2007 2:12 AM
Subject: same sql, same execution plan, but the time to complete is very 
different when run in different time.





 



--



http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 12 2007 - 06:59:28 CST












Original text of this message













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