Q
Problem solve Get help with specific problems with your technologies, process and projects.

Factors to consider when creating a new database

1. Could you please explain what factors should be taken into account while creating a new database?

2. How can I decide when creating a new database the amount of RAM allocated and the number of CPUs?
1. You need to know the amount of total memory available on the box, how much is already in use (either by other Oracle instances or other tools/apps/products), how much disk space and its configuration, the number and type of users expected for your new database and the backup strategy you will want to use.

2. Look in the install guide for your OS to determine any max limits on SGA size and then use as much as you have reasonably available for Oracle. Some OS's have a limit as to how big the SGA can get. Make sure to not exceed any limits. As far as the number of CPUs, this is shown to you in the parameter cpu_count and is assessed by Oracle.

Dig Deeper on Oracle database installation, upgrades and patches

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close