|Oracle Enterprise Manager Database Tuning with the Oracle Tuning Pack
Part Number A86647-01
Initial configuration implies that database attributes and parameters must be formed prior to building the desired database. However, that is not necessarily the easiest method to use.
When you use Oracle Expert to help configure a new database, you should allow the Oracle Server to create a default instance of the database and then build upon that implementation. By allowing creation of a default database, you enable Oracle Expert to acquire automatically much of the needed information regarding your database.
This chapter describes the following:
When you use Oracle Expert for initial configuration tuning, Oracle Expert can provide more appropriate instance parameters for the database than the Oracle Server default instance parameters. Oracle Expert takes the following data into account before recommending instance parameters for the database you are creating:
Includes memory and CPU data, plus the operating system page size.
Includes the version of the database, specified options, and database user, tablespace, and public synonym data.
Includes data about the type of application (OLTP, Data Warehousing, or Multipurpose) that runs against the database, tolerance for unscheduled downtime, and other tuning session values.
Oracle Expert analyzes all this data before providing instance parameter recommendations. Oracle Expert makes better recommendations when provided with complete and accurate system, database class, and tuning session data.
Initial configuration allows you to start with a newly created Oracle database and quickly customize the database for your environment. As additional information about the environment becomes available, use Oracle Expert to further tune the database.
Perform the following steps:
Once you have performed the initial configuration of your new database, improve on the initial configuration by performing the following steps:
Now that the instance has been tuned, Oracle Expert will be able to provide good results when you perform application tuning and structure tuning.
Providing accurate information about the following aspects of your database helps Oracle Expert generate a good initial configuration:
If you cannot provide an exact value for some of these items, you can specify a range of values using control parameters, and Oracle Expert will use this data to make initial configuration recommendations. In some cases, Oracle Expert can make initial configuration recommendations for part of your database even when you are unable to provide all the previously mentioned information.