Keeping Lookup Tables in Memory

Re: Oracle paging algorithm and performance

I have ~20 lookup tables under 100K in size. I would like to keep these in memory at all times. However, because there are several *large* tables being accessed, it would *seem* that these lookup tables would be paged out often and then (because it is a lookup table) be pulled in from disk so after. So does Oracle have a method around this, or is it a moot point because of some factor I forgotten? - or - What the bases of Oracles paging algorithm?

Thanks for you thoughts,

John Dennis
Atlanta, GA Received on Thu Jun 09 1994 - 16:37:20 CEST