You
should take a two-step approach for any new databases you create. First, understand the
purpose of the database, and then create the database with the appropriate parameters.
Planning the Database
As with installing the Oracle software, you should spend some time learning the purpose
of an Oracle database before youcreate the database itself. Consider what the
database will be used for and how much data it will contain. You should understand
the underlying hardware that you??™ll use??”the number and type of CPUs, the amount
of memory, the number of disks, the controllers for the disks, and so on. Because the
database is stored on the disks, many tuning problems can be avoided with proper
capacity and I/O subsystem planning.
60 | Chapter 3: Installing and Running Oracle
Planning your database and the supporting hardware requires insights into the scale
or size of the workload and the type of work the system will perform. Some of the
considerations that will affect your database design and hardware configuration
include the following:
How many users will the database have?
How many users will connect simultaneously and how many will concurrently
perform transactions or execute queries?
Is the database supporting OLTP applications or data warehousing?
This distinction leads to different types and volumes of activity on the database
server.
Pages:
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153