Re: Memory Sizing - Data Warehouse

george bagley wrote:

> Hi
>
> I need to estimate memory for our new database.
>
> We expect to have about 120 million records, with about 50GB raw data
> and 40+GB indexes.
>
> We run a lot of filters and cleaning tools over this data (all
> written in PL/SQL).
>
> We generally add 1 to 1.5 million rows each day using sql-loader.
>
> This data is then summarised and manipulted as a batch process over
> night.
>
> We are running on Dell 6400's with 4 processors on Redhat Linux
> Advanced Server.
>
> Also, if we get 4GB RAM, should I increase SGA to > 1.5GB, sort size
> to 100MB etc
>
> There are only four users on the system at any one time running
> reports.
>
> Any ideas or suggestions would be greatly appreciated.
>
> Thanks
>
> George

Tuning is not something you do in a dark closet with the lights out. If you can get 4GB of RAM get it. But that doesn't necessarily mean using all of it will help you as I have no idea what your code is or does. But sizing the SGA is something one does by experimentation ... A larger SGA does not necessarily make things faster. In fact it can make them slower. So the order of the day is to test and tune on a continuing basis.

Daniel Morgan Received on Fri Aug 30 2002 - 13:45:48 CDT