Re: How to keep a table in memory? Oracle 10g

On Mar 3, 6:16 pm, Pete <pmussom..._at_gmail.com> wrote:
> On Mar 3, 1:23 pm, "Sam" <ysa..._at_yahoo.com> wrote:
>
> > Hi There,
> > I have a table with heavy select queries on it, with almost no Insert or
> > Update.
> > Is there a way to make Oracle keep this table or a View of this table in
> > memory(RAM)? for faster access?
> > I have enough RAM on the system and tables are not that big,
> > Any suggestions?
>
> > I use:
> > Oracle: 10g 10.2.1.0
> > OS: Windows Server 2003
>
> > Thank you in advanced
>
> you don't really need to do this if your large pool parameter is set
> appropriately, but if you must, check out
> dbms_shared_pool.keep(<object>,<type>);.

I'm sorry, but in what part of v$bh refers to the shared pool or large pool?
I must have missed that somewhere along the way of reading the documentation in this area. Can you point out an official doc that refers to keeping data blocks in the large pool via dbms_shared_pool? <EG>
Perhaps its an undocumented parameter that I need to purchase additional documentation to leverage?

-bdbafh

(not referring to direct reads and writes which could/would bypass the buffer caches).

Paging Mladen ... Received on Mon Mar 03 2008 - 17:44:31 CST