DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Allocate buffers in Library cache!

  1. 10-29-2001, 08:31 AM #1
    amitstora
    amitstora is offline Senior Member
    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.
    Reply With Quote Reply With Quote
  2. 10-29-2001, 08:33 AM #2
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Yes you should,
    add value for shared_pool_size.
    Reply With Quote Reply With Quote
  3. 10-29-2001, 08:34 AM #3
    Sureshy's Avatar
    Sureshy
    Sureshy is offline Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width