Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Keep Pool

Re: Keep Pool

From: joel garry <joel-garry_at_home.com>
Date: 21 Jun 2006 15:55:36 -0700
Message-ID: <1150930536.771289.296790@b68g2000cwa.googlegroups.com>

art_at_chicagorsvp.com wrote:
> Hi Everyone!
>
> We are running Oracle 9.2.0.7. Is there a way to query what objects
> are pinned in the keep pool???
>
> Regards.

Actually, you pin objects in the shared pool, not the keep pool. You simply tell objects to use the keep pool and hope they stay. But often, getting things that use lots of different rows out of the default pool and into the recycle pool lets the rest stay in the default pool and you don't even need the keep pool unless you have lots of things that thrash lots of different objects.

So, are you worried about the shared pool or the keep pool, and what are you trying to accomplish?

jg

--
@home.com is bogus.
"Please stand to the right.  If you wish to pass, please do so on the
left." - Background announcement in THX-1138
Received on Wed Jun 21 2006 - 17:55:36 CDT

Original text of this message

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