Re: Will more memory help
Date: Fri, 30 Oct 1998 18:46:08 GMT
Message-ID: <363A098B.EE6B788B_at_bellsouth.net>
Generally speaking (very generally) a large buffer cache will not have a great deal of benefit for a data warehouse. The typical data warehouse using parallel query will be doing full tablespace scans. Normally, full tablespace scans will not leave the blocks it reads in the buffer cache.
I would look at increasing the hardware io speed for performance. Also, if you are sorting to disk, increase the sort_area_size. You might also consider using bitmapped indexes instead of btree (if you have not already done this).
If you want more ideas on the turing, email me privately.
Darrell & Janine Brown wrote:
>
> I work in a Data Warehouse.
>
> We currently have a quad-pentium 200 w/ 1 GB RAM running WinNT 4. We are
> using Oracle 7.3 with parallel server/parallel query options. The
> database takes up 60GB of a 90GB Raid array.
>
> We have the opportunity to obtain a second GB of RAM.
> Will the addition of the extra memory produce a noticible difference?
> Where can I find information on the degree of difference?
>
> Thanks in advance.
>
> Darrell Brown
> Programmer-Analyst
> MTS Communications Inc.
Received on Fri Oct 30 1998 - 19:46:08 CET