Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Lookup/Code table as hot block

Lookup/Code table as hot block

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Wed, 19 Apr 2006 16:47:25 -0400
Message-ID: <367369f10604191347m428bf7c0i19038d5a76ca202b@mail.gmail.com> 





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



--



http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 19 2006 - 15:47:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US