Oracle High Performance Tuning for 9i and 10g
This text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration, and explains both problem detection and resolution.
TABLE OF CONTENTS Oracle High Performance Tuning for 9i and 10g
Chapter 11: Installing Oracle and Creating a Database
So far in this book we have covered both data model and SQL code tuning. Part III deals exclusively with physical and configuration tuning. Probably the most essential parts of this type of tuning Oracle Database could be the first two steps you ever take with Oracle Database. These two steps are installing Oracle software and creating a database; in this chapter we will focus on just that. The configuration parameter file is an integral part of that process.
11.1 Installing Oracle Database
Oracle9 i Database installs a lot of extra options if you let it. One way to install Oracle software without the extra options is to do a custom installation and select only the required options. Avoiding installing unwanted options will not necessarily help performance but it can make administration and ultimately tuning a lot easier in the long run. However, this can cause problems because any missing components could have to be added at a later stage.
| Note | Oracle Database 10 Grid The general trend is towards more automation, both with installation, configuration and the underlying physical architecture of an Oracle database in general. On the whole, Oracle Database 10 g is very much simplified from Oracle9 i Database. |
11.1.1 Different Editions of Oracle Database
The three different editions are Personal Oracle, Standard Edition, and Enterprise Edition. Personal Oracle is intended for use on a single machine and Standard Edition is a trimmed down, cheaper version of Enterprise Edition. There are also additional optional...
Copyright Elsevier Inc. 2004 under license agreement with Books24x7
