PL/SQL program needs to be recompiled frequently.

/SQL program that spends most of the time executing SQL

PL/SQL program , which performs computation-intensive procedural operations and is recompiled rarely

PL/SQL program , which is called frequently with the same parameter values by multiple sessions and is recompiled rarely.