SHARED_SERVERS The number of shared server processes to allocate when an instance
is started.
STAR_TRANSFORMATION_ENABLED Controls query optimization when start queries are executed.
UNDO_MANAGEMENT Specifies whether undo management is automatic (AUTO) or
manual (MANUAL). If MANUAL is specified, rollback segments are
used for undo management.
UNDO_TABLESPACE The tablespace to use when UNDO_MANAGEMENT is set to AUTO.
TABLE 1-3 Basic Initialization Parameters (continued)
Some of these parameters will be revisited in the appendix, where we will set the initial
parameters for the SGA, file locations, and other limits.
COMPATIBLE
The COMPATIBLE parameter allows a newer version of Oracle to be installed while restricting the
feature set of the new version as if an older version of Oracle was installed. This is a good way to
move forward with a database upgrade while remaining compatible with an application that may
fail when it runs with the new version of the software. The COMPATIBLE parameter can then be
Chapter 1: Getting Started with the Oracle Architecture 45
bumped up as the applications are reworked or rewritten to work with the new version of the
database.
The downside of using this parameter is that none of the new applications for the database
can take advantage of new features until the COMPATIBLE parameter is set to the same value as
the current release.
DB_NAME
DB_NAME specifies the local portion of the database name.
Pages:
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132