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: Jared Still <jkstill_at_gmail.com>
Date: Mon, 1 May 2006 15:59:50 -0700
Message-ID: <bf46380605011559u313f85d9ndc869f3fa8595ee4@mail.gmail.com>


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
Received on Mon May 01 2006 - 17:59:50 CDT

Original text of this message

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