| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Procedures and Choosing the QEP
A copy of this was sent to steve_mundie_at_my-dejanews.com
(if that email address didn't require changing)
On Mon, 19 Apr 1999 11:01:09 GMT, you wrote:
>
>
>I know that procedures are stored compiled but when do the
>execution plans for the statements in them get chosen?
>
the queries within plsql are optimized (plans generated for) the first time they are executed after the database has been started up OR after their plans have been aged out of the shared sql cache. plsql SQL statements are treated just like any other SQL statements executed by any other environment -- they are managed by the shared SQL area.
>I've had a look through the Oracle8 documentation (I'm running on AIX) but
>can't find this information.
>
>Steve Mundie
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |