Re: execution plan of a stored procedure

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 10 Jan 2005 07:48:56 +0100
Message-ID: <u994u056sdltfi1osages1kn83q13acbit@4ax.com>

On 9 Jan 2005 22:37:47 -0800, "roark" <RodionRaskolnikov_at_gmail.com> wrote:

>hi,
>
>A stored procedure is said to be 'pre-compiled'. In oracle 9i, is the
>execution plan of the stored proc part of this compiling process? I
>mean, if the CBO statistics change, will the stored procedure still
>retain the old plan?
>
>thanks,
>roark

execution plans are not stored.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Jan 10 2005 - 00:48:56 CST