Re: ref cursor slow compared to sql query

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 28 Jun 2004 19:42:47 +0000 (UTC)
Message-ID: <cbpsbn$3mo$1@hercules.btinternet.com>

Don't make jokes like that.

If you check the list of (hidden) parameters and some of the background work being
done, you'll spot the clues that it probably will happen in some release 'real soon now'.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
news:ian0e0547d9lsafv9si6a4c88tjuorkh9u_at_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 - 14:42:47 CDT