The best you can do to optimize something is to stop doing it.
In this case it might be caching table content and refreshing
periodically or based on some criteria.
2006/4/19, Ranko Mosic <ranko.mosic_at_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
>
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 19 2006 - 16:05:54 CDT
