I'm trying to use buffer cache more effectively on a warehouse system. There are several tables between the external table and the fact table where the data will live. The interim tables are there to allow partition wise joins and break the data up into manageable sizes. Since I'm only inserting into and selecting from each interim table once, I don't think the buffer cache is helping me at all. With that in mind, I think it makes sense the change these tables to use buffer_pool recycle, and set db_recycle_cache_size=0. Right now there aren't any tables configured to use the recycle buffer pool. Are these changes reasonable? I'll be happy to provide more information as necessary. Changes of this type are a bit out of my depth, so any advice you have would be helpful. Thanks!
-----------------------------------------
I cannot be bought. Find leasing information at
-----------------------------------------
I cannot be bought. Find leasing information at