I would usually expect to assign a few special
objects to the KEEP pool, a few to the RECYCLE
pool, and leave most in the DEFAULT pool.
--
Jonathan Lewis
Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html
Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html
Screensaver or Lifesaver: http://www.ud.com
Use spare CPU to assist in cancer research.
Chuck Hamilton wrote in message ...
>What is the best way to use multiple buffer pools? Should most
>segments still be assigned to this pool? Or should most be assinged to
>either KEEP or RECYCLE depending on object usage?
>
>I currently have everything in the DEFAULT pool with about a dozen
>segments assigned to KEEP. The KEEP pool size is slighly larger than
>the sum of the blocks used by those objects. Those objects are tables
>that are scanned very frequently but are small in size. Is this a good
>usage of multiple buffer pools?
>--
>Chuck Hamilton
>chuck_hamilton_at_yahoo.com
>
>"Do not be deceived, God is not mocked;
>for whatever a man sows, this he will also
>reap." (Gal 6:7 NASB)
Received on Fri Jul 27 2001 - 13:13:28 CDT
