dbmspool.sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dbmspool.sql

  1. #1
    Join Date
    Jun 2001
    Posts
    316
    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

  2. #2
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    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.
    There Nothing You cannot Do, The problem is HOW.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width