dbmspool.sql

[helpme]

Hi guys,

We are tuning up our database for a better performance and i read somewhere that we can pinn a procedure/function into the RAM using the dbmspool.sql package?
How do i go about it..and would it really effect the performance?

Thanx a lot
Sam

[sudip]

It is going to help those packages and procedure which will be extensively used by the application. These procedures and packages will never be taken out of the memory and the application demanding the specific procedures and packages will always find them in memory and will not have to recompile them.
the package is dbms_shared_pool.keep pins the specific package/procedure in the memory.