Q

How many database instances can be created?

How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space?

How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space?

Processor: 1.8Ghz P-4
Memory: 512BM
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.

This was first published in May 2007

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close