Lookup/Code table as hot block

Hi List,
I have couple of thousand of users all accessing the same, very small lookup table.
This is hot block in database cache.
How can I avoid this ? Multiple table copies ? How to do this - all users connect under single name .

--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html


Hi List, 
I have couple of thousand of users all accessing the same, very small lookup table. 
This is hot block in database cache. 
How can I avoid this ? Multiple table copies ? How to do this - all users connect under single name .

-- 
Regards, 
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional

Phone: 416-450-2785
email: mosicr@rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
 
 

--
http://www.freelists.org/webpage/oracle-l