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: ref cursor slow compared to sql query

Re: ref cursor slow compared to sql query

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Mon, 28 Jun 2004 20:03:34 +0200
Message-ID: <ian0e0547d9lsafv9si6a4c88tjuorkh9u@4ax.com> 





On Mon, 28 Jun 2004 10:56:51 -0500, Turkbear <john.g_at_dot.spamfree.com>
wrote:



>If you are running the Sql immediately after the proc, the data is likely in the cache  so it would have a different

>execution plan.




Please explain why data in the buffer cache would result in a
different execution plan. What version is that? 11h?



--
Sybrand Bakker, Senior Oracle DBA


Received on Mon Jun 28 2004 - 13:03:34 CDT












Original text of this message













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