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

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

Re: Lookup/Code table as hot block

From: Syed Jaffar Hussain <sjaffarhussain_at_gmail.com>
Date: Tue, 2 May 2006 12:15:28 +0300
Message-ID: <97b7fd2f0605020215u4e82c270xae3fb0294639fd82@mail.gmail.com>


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

On 5/2/06, Bobak, Mark <Mark.Bobak_at_il.proquest.com> wrote:
> Or you can use the minimize records per block trick....
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org on behalf of Jared Still
> Sent: Mon 5/1/2006 6:59 PM
> To: ranko.mosic_at_gmail.com
> 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_at_gmail.com> 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_at_rogers.com
> >
> > http://ca.geocities.com/mosicr@rogers.com/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_at_rogers.com
> > http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
> >
> >
> >
> >
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
> --
> http://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."
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 02 2006 - 04:15:28 CDT

Original text of this message

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