Re: Anyone able to pin a table to memory

"TimKArnold" <timkarnold_at_aol.com> wrote in message news:20000829083201.24962.00001138_at_ng-cj1.aol.com...
> alter table <tablename> cache
>

Doesn't guarantee anything at the best of times, has been of dubious benefit since Oracle 8, and is totally redundant in 8i.

Wouldn't bother.

The simplest way to *try* to keep a table in memory is to have a larger database buffer cache to start with. And then you can start dabbling with keep buffer pools (see
http://technet.oracle.com/doc/oracle8i_816/server.816/a76992/ch19_mem.htm) for details, and search for the phrase "Overview of the Multiple Buffer Pool Feature")

Not much use to you if you haven't got 8i, though, I guess.

Regards
HJR
> >Hi,
> >
> >I have been asked to see if it is possible to pin a table to memory.
 Anyone
> >know how to do this or no off a good third part tool to sit on top of
 oracle
> >for mission critical access times.
> >
> >TIA
> >
> >Nick
> >
> >
> >
> >
> >
> >
> >-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> > *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
> > http://www.usenet.com
>
Received on Sat Sep 02 2000 - 17:49:45 CDT