Ask the Expert

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?

Processor: 1.8Ghz P-4
Memory: 512BM
Mother board: Intel 845

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: