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