Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> 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