creating a database

creating a database - you in the parameter cpu_count and is...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: you in the parameter cpu_count and is assessed by Oracle. The questions to ask include: o What is your level of education? o How long have you been in business? o Will you be using SQL? (Yes) o Will you be using more than one table to hold different domain values? (Yes) o Will you build generic objects? (No) o Will you run a complete test of the system? (Yes) o Will you train my employees to use the program? o What will you do if we have a problem? The cost variables that have to do with your needs include: o How many users will access the information? o What type of functions do you need? o How much information do you need to store?...
View Full Document

Ask a homework question - tutors are online