Processor: 1.8Ghz P-4
Mother board: Intel 845
An Oracle database requires more than just physical disk space; it also requires system resources and memory. From the specifications of your server, I would say that the limiting factor to how many databases you can create is the memory available, not the physical disk available. It also depends on the release of Oracle your databases will be, and how you configure the SGA (system global area) since this impacts memory usage the most. With only 512 MB of memory available, I would guess that you might be able to squeeze two Oracle databases (with small SGA sizes) on this server.
For more information on what to consider when creating a database, refer to the appropriate administrator's guides. If you are planning to create Oracle9i databases, refer to the Oracle9i Release 2 (9.2) Database Administrator's Guide. For creating Oracle 10g databases, the Oracle 10g Administrator's Guide.
Dig Deeper on Oracle database design and architecture
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.