Re: loading database in memory
Date: Wed, 24 Jul 2002 15:27:18 GMT
Message-ID: <qHz%8.2229$eb.1867_at_nwrddc04.gnilink.net>
If you are seriously thinking about doing that, remember that it will become
volitale. If you loose power all updates can be lost. An alternative would
be to look at Solid State Disks. You can load your hot files or even the
database and it will be protected while giving you the access and write
speeds of the memory.
B Levitt
www.evenenterprises.com
"Vissu" <vissuyk_at_yahoo.com> wrote in message
news:2bedd6a7.0207171857.3084a517_at_posting.google.com...
> Hi All,
>
> I am thinking of loading the current partition of one of tables into
> memory and keep it there. Many of our queries look for latest data. I
> know that 9i introduced db_cache_keep_size for things like this.
> However, I am not sure how a an individual partition can be loaded.
> Does anyone know how to do this ?.
>
> Thanks for any help
>
> Vissu
Received on Wed Jul 24 2002 - 17:27:18 CEST