Re: Pinning Objects

From: The Magnet <art_at_unsu.com>
Date: Mon, 20 Jul 2009 11:04:42 -0700 (PDT)
Message-ID: <07b39bf4-bce7-4745-b5b5-b9c05b99568f_at_k30g2000yqf.googlegroups.com>



On Jul 20, 12:35 pm, ddf <orat..._at_msn.com> wrote:
> On Jul 20, 11:57 am, The Magnet <a..._at_unsu.com> wrote:
>
> > Hi,
>
> > We want to pin a couple of tables, hoping to increase some
> > performance.  From the docs, a pinned table means less reads from
> > disk, etc.
>
> > If the table gets updated or inserted into, is there any advantage to
> > this?  If yes, how does the committed transactions get saved?
>
> Why do you not consider using the KEEP pool?
>
> http://oratips-ddf.blogspot.com/2008/05/thats-keeper.html
>
> David Fitzjarrell

I think that is what I meant:

EXEC DBMS_SHARED_POOL.keep('mf_functions'); alter TABLE subscriptions storage (buffer_pool keep);

But was curious about tables with heavy DML..... Received on Mon Jul 20 2009 - 13:04:42 CDT

Original text of this message