Re: Help for hardwre quantity

Frederic Houbie wrote:

> Hi,
>
> we will have a Oracle DB with 100000 Gb of Data. Where can I find a
> formula to calculate the approximate quantity of RAM this serveur needs ?
> Thanks
>
> Frédéric

1GB is more than sufficient.

That was a joke as is your question. There is no relationship between the amount of hard disk required for storage and the amount of RAM required to support Oracle and user processes. I could easily use 512MB of RAM to run a database with 100TB of data. Just don't have more than one person at a time run a query.

How many simultaneous transactions?
What is the average transaction size?
What is the largest transaction size?
What is the duration of the average transaction? What is the duration of the longest transaction? Based on an AWR or StatsPack analysis what is the bottleneck going to be? And what version of Oracleon what operating system?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)