Re: 10g - Need advise on large lookup table and optimizing io

Can you put the index in the keep pool and add to your SGA (DB_KEEP_CACHE_SIZE) the number of blocks v$bh shows it has been using?  Something under a gig, I'd guess from your post, and if it is that heavily used, you might be able to shrink your regular buffers some. Helps to post version and platform and appropriate configuration parameters.

jg

-- 
@home.com is bogus.
http://catless.ncl.ac.uk/Risks/24.14.html#subj11