Re: prepare procedure

From: Gazza <garywaldrom_at_hotmail.com>
Date: Wed, 17 Nov 1999 13:04:13 -0000
Message-ID: <942844261.11382.0.nnrp-07.c1ed75d0@news.demon.co.uk>

You might wish to look at pinning the procedure into the SGA by running the DBMS_SHARED_POOL.KEEP package

--
Gary Waldrom
Amonra Insight - Makers of Q-file IT Reference Guides http://www.q-file.com

Erik Ulven <erik_at_quasar.no> wrote in message news:3832877E.D9ED9812_at_quasar.no...
> Hello,
>
> I wonder if there is possible to prepare a procedure before running it.
> We use a pretty heavy procedure, and it uses a long time on first run,
> but the next run it uses almost half the time. In delphi I used to call
> prepare before calling procedures, but how can i do this in oracle sql?
>
> Best regards,
>
> Erik
>
Received on Wed Nov 17 1999 - 07:04:13 CST