RE: Lookup/Code table as hot block

First question is how are they accessing it?  If via PK then making it
into an index organized table can cut your lio in half since you won't
be doing an index block read.

 

 

 

Thanks,

Jay Miller

Sr. Oracle DBA

x68355

 

-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] 
Sent: Wednesday, April 19, 2006 4:47 PM
To: _oracle_L_list
Subject: 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@rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMo

sicMain.html 
 




-----------------------------------------
This message is confidential and sent by TD Waterhouse solely for
use by the intended recipient. If you are not the intended
recipient, you are hereby notified that any use, distribution or
copying of this communication is strictly prohibited. This should
not be deemed as an offer or solicitation, to buy or sell any
product. Any 3rd party information contained herein was prepared by
sources deemed reliable, but is not guaranteed. TD Waterhouse does
not accept electronic instructions that would require an original
signature. Information received by or sent from TD Waterhouse is
stored, subject to review, and may be produced to regulatory
authorities or others with a legal right to such.

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