Allocate buffers in Library cache!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Allocate buffers in Library cache!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

    1.I have Library Cache filled up and there is no room for more sql statements.
    How should I increase/allocate more buffers to the Library cache.

    Thanks&Regards,

    Amit.

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Yes you should,
    add value for shared_pool_size.

  3. #3
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Shut down db
    Increase value of shared_pool parameter in init file
    restart
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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