I think minimize records_per_block is use when there is bitmap index on it. If the tables has index on it, I hope that root block of the index is not the cause for hot block.
Jaffar
Or you can use the minimize records per block trick....
-----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Jared Still Sent: Mon 5/1/2006 6:59 PM To: ranko.mosic@xxxxxxxxx Cc: _oracle_L_list Subject: Re: Lookup/Code table as hot block
One method to deal with this is to rebuild the table with a sufficiently high pctfree that there is only one row per block.
Jared
On 4/24/06, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote: > > 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 > > > 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 > > > >
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
-- //www.freelists.org/webpage/oracle-l
-- Best Regards, Syed Jaffar Hussain 8i,9i & 10g, OCP DBA Banque Saudi Fransi, Saudi Arabia http://jaffardba.blogspot.com/ ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- //www.freelists.org/webpage/oracle-l