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: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 2 May 2006 02:45:06 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF2703268806@AABO-EXCHANGE02.bos.il.pqe>


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
Received on Tue May 02 2006 - 01:45:06 CDT

Original text of this message

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