you may partition your tables, but you should consider i/o performance of
your disks (ess, emc, internal etc ?).
another thing, which criteria your 4 users intend to utilize in their sql
query (i think this is the first factor for your database's performance...)
hth
yang
"george bagley" <george_working_at_hotmail.com> wrote in message
news:ad097928.0208300835.433ba303_at_posting.google.com...
> 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
Received on Fri Aug 30 2002 - 15:42:41 CDT
