Lookup/Code table as hot block
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: _oracle_L_list <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Apr 2006 16:47:25 -0400
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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
Other related posts:
