Re: Stored Package/Procedure Performance
From: N Prabhakar <N_Prabhakar_at_Socgen-Crosby.com>
Date: 1996/11/22
Message-ID: <572t1r$21e_at_newton.pacific.net.sg>#1/1
Date: 1996/11/22
Message-ID: <572t1r$21e_at_newton.pacific.net.sg>#1/1
Tom Ray <tom.ray_at_turner.com> writes: > I am looking for parameters that can improve the performance of stored
> procedures and packages.
Hi there,
You can pin stored procedures after the database is opened. This will enable Oracle to store all the packages / procedures / function is a contiguous memory and it will prevent fragmentation.
You can pin your large procedures / packages which will be frequently used in your system
The syntax is
execute dbms_shared_pool.keep('procedure_name');
Regards
N.Prabhakar Received on Fri Nov 22 1996 - 00:00:00 CET