Oracle server requirements calculation Is there a standard methodology for determining how much CPU, memory and disk space is needed to support an Oracle database with 500 million rows of sensor data (and counting) ? The system in question is a SCADA database gathering sensor data from hundreds of field devices on a daily basis. The same database is used for reporting and analysis (a watershed and wastewater management system for a major municipality).
You can roughly calculate current disk space requirements by using guidelines from the Oracle documentation, once you have defined your schema, including the necessary indexes and materialized views, if any. Do not forget to add space for backups and archived logs.

As for the CPU and memory requirements, they would mostly depend on the exact characteristics of your workload, given the schema defined earlier. In this day and age you should be able to spin up a virtual server with one of the cloud providers and run your load tests (you do have a load test suite, right?) against it much faster than trying to find some magical generic formula on the internets.