Re: Data storage question

Steve Haynes wrote in message ...
>In article <7ps6of$cp1$1_at_autumn.news.rcn.net>, Jerry Gitomer
><jgitomer_at_hbsrx.com> writes
>>queries). In fact if you are using Oracle 8 you can lock your
>>indexes in RAM and your system will fly.
>>
>How?, this is new one to me.

In the CREATE statement. (If I remember correctly its the CACHE option.

>
>Assuming alter index keep or something, what if the
>indexes are too large for ram? - warehouses etc.
>Won't you lose any benefit in swapping?

He said he had 5,000,000 rows and that there was an average of 2 attributes per row. Assuming (always very dangerous) an index entry size of 32-characters per entry and 15 million entries it would require 480MB to keep all of the indexes in RAM. Given that you can get 4GB for a Pentium this should not be a problem.
>
>This sounds best left to to memory algorithms as a
>first reaction. Can anyone enlighten me?

If you are dealing with a narrowly defined problem that you understand very well and you have a pretty good knowledge of Oracle you MAY be able to do a better job of managing than the Oracle will do, but -- and its a big but -- in most cases it is best to leave memory management to Oracle.

regards
Jerry Gitomer

>
>Thanks,
>Steve
>--
>Please remove nospam from my address to Reply.
Received on Tue Aug 24 1999 - 07:40:51 CDT