Re: Lookup/Code table as hot block

Thanks.

On 4/21/06, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
>
> Consider reading these 3 rows in the beginning of the session. You can
> have consider invalidating the cache after certain time and relod it.
> This is suitable if you have persistent connections and data might
> change on the server from time to time.
>
> 2006/4/21, Ranko Mosic <ranko.mosic@xxxxxxxxx>:
> >
> > But then you have to manually keep application in sync with table - no
> good.
> > Current idea is ( on app side ) to read it once at the beggining of the
> > session, cache into array and use from there - so buffer cache is not
> used
> > any more, just UGA ( as Tanel suggested ).
> >
> > Regards, Ranko
> >
> >
> > On 4/21/06, Ranko Mosic <ranko.mosic@xxxxxxxxx> wrote:
> > >
> > >
> > > That's the idea actually. Those 3 rows should stay away from Oracle.
> > > Thanks Alex.
> > >
> > >
> > >
> > > On 4/21/06, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
> > > > Why don't you cache 3 rows in the application? You would avoid all
> > > > kind of problems with concurrent access then.
> > > >
> > > > 2006/4/20, Ranko Mosic <ranko.mosic@xxxxxxxxx>:
> > > > >
> > > > > Thanks all for their responses. I apologize for not having more
> detail
> > -
> > > > > this is yet another
> > > > > 4 pm issue. Version is 9.2.0.x. This table has only 3 ( three )
> rows,
> > so any
> > > > > points relating to pk/indexes/IOT etc don't apply here.
> > > > > Why is this bad thing ? I don't know, I asked client the same
> > question, but
> > > > > they seem sure
> > > > > they are seeing problem. I didn't have chance yet to have direct
> look
> > at the
> > > > > problem.
> > > > > Caching is current idea and also suggested by Oracle Consulting.
> > > > > I am not sure how much it will help though - block is cached
> anyway,
> > so
> > > > > buffer cache latch will be replaced with shared pool latch.
> Spreading
> > > > > accross 3 blocks is also considered.
> > > >
> > > >
> > > > --
> > > > Best regards,
> > > > Alex Gorbachev
> > > >
> > >
> > >
> > >
> > >
> > > --
> > > 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
> > >
> >
> >
> >
> > --
> > 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
> >
>
>
> --
> Best regards,
> Alex Gorbachev
>



--
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

Other related posts: