You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for initialization parameter


1 to 40 of 13202 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

UNDO_MANAGEMENT Initialization ParameterThe UNDO_MANAGEMENT initialization parameter determines whether or not an instance starts in … automatic undo management mode, which stores undo in an undo tablespace. Set this parameter to AUTO to … enable automatic undo management mode. Beginning with Release 11 g, AUTO is the default if the parameter is omitted or

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

Sample Initialization Parameter FileOracle Database provides generally appropriate values in a sample text initialization parameter … file. You can edit these Oracle-supplied initialization parameters and add others, depending upon your … configuration and options and how you plan to tune the database. The sample text initializationparameter

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

DB_NAME Initialization Parameterdatabase. If during database instance startup the value of the DB_NAME parameter (in the parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Using the DBMS_REPAIR Package

DB_BLOCK_CHECKING Initialization ParameterYou can enable database block checking by setting the DB_BLOCK_CHECKING initialization parameter to … always enabled for the system tablespace. See Also: Oracle Database Reference for more information about the DB_BLOCK_CHECKING initialization parameter … . DB_BLOCK_CHECKING is a dynamic parameter, modifiable

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

DB_BLOCK_SIZE Initialization ParameterDB_BLOCK_SIZE initialization parameter is valid: DB_BLOCK_SIZE=4096 A larger data block size provides greater … . If you do not set a value for this parameter, the default data block size is operating system

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

DB_DOMAIN Initialization Parameterattention to this initialization parameter before database creation. This parameter is optional. See

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

UNDO_TABLESPACE Initialization Parameterthe instance by specifying a value for the UNDO_TABLESPACE initialization parameter. This parameter is … initialization parameter, then the first available undo tablespace in the database is chosen. If no undo … statement to create a database, do not include an UNDO_TABLESPACE parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

The SPFILE Initialization ParameterThe SPFILE initialization parameter contains the name of the current server parameter file. When … the default server parameter file is used by the database—that is, you issue a STARTUP command and do … not specify a PFILE parameter—the value of SPFILE is internally set by the server. The SQL*Plus

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Changing Initialization Parameter Valuesinitialization parameters. If you are using a text initialization parameter file, the ALTER SYSTEM statement … changes the value of a parameter only for the current instance, because there is no mechanism for … automatically updating text initialization parameters on disk. You must update them manually

Database Administrator's Guide, 11g Release 1 (11.1)

Configuring Oracle Database for Shared Server

DISPATCHERS Initialization Parameter AttributesDISPATCHERS initialization parameter. A protocol address is required and is specified using one or more of … descriptions of the attributes of the DISPATCHERS initialization parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Clearing Initialization Parameter ValuesYou can use the ALTER SYSTEM RESET command to clear (remove) the setting of any initializationparameter in the SPFILE that was used to start the instance. Neither SCOPE = MEMORY nor SCOPE = BOTH are … parameter in the SPFILE so that upon the next database startup a default value is used. See Also

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

About Initialization Parameters and Initialization Parameter Filesparameter file. For any initialization parameters not specifically included in the initialization parameter … file, the database supplies defaults. The initialization parameter file can be either a read-only … parameter file enables you to change initialization

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Resumable Space Allocation

Setting the RESUMABLE_TIMEOUT Initialization ParameterRESUMABLE_TIMEOUT initialization parameter. For example, the following setting of the … RESUMABLE_TIMEOUT parameter in the initialization parameter file causes all sessions to initially be enabled for … SESSION SET statement to set the RESUMABLE_TIMEOUT initialization parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Enabling the Creation and Use of Oracle-Managed Files

Setting the DB_CREATE_FILE_DEST Initialization ParameterInclude the DB_CREATE_FILE_DEST initialization parameter in your initialization parameter file to

Database Administrator's Guide, 11g Release 1 (11.1)

Planning the Redo Log

Setting the ARCHIVE_LAG_TARGET Initialization ParameterWhen you set the ARCHIVE_LAG_TARGET initialization parameter, you cause the database to examine the … current log), where n + m exceeds the value of the ARCHIVE_LAG_TARGET initialization parameter. The … ARCHIVE_LAG_TARGET initialization parameter specifies the target of how many seconds

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

About The COMPATIBLE Initialization ParameterThe COMPATIBLE initialization parameter enables or disables the use of features in the database … ) database, but specify COMPATIBLE = 10.0.0 in the initialization parameter file, then features that … advance the compatibility of your database with the COMPATIBLE initialization parameter,

Database Administrator's Guide, 11g Release 1 (11.1)

Specifying Initialization Parameters

Text Initialization Parameter File FormatThe text initialization parameter file (PFILE) must contain name/value pairs in one of the … Reference for more information about the content and syntax of the text initialization parameter file \"Alert Log\" … accept one or more values (such as the CONTROL_FILES parameter): parameter_name=(value[,value

Database Performance Tuning Guide, 11g Release 1 (11.1)

The Query Optimizer

11.2.1 OPTIMIZER_MODE Initialization ParameterThe OPTIMIZER_MODE initialization parameter establishes the default behavior for choosing an … . Table 11-2 OPTIMIZER_MODE Initialization Parameter Values Value Description ALL_ROWS The optimizer uses … statements in a session by changing the parameter value in initialization file or

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Setting or Changing Initialization Parameter ValuesUse the SET clause of the ALTER SYSTEM statement to set or change initialization parameter values … instance, and MEMORY if a text initialization parameter file was used to start up the instance. For dynamic … tighter security.' SCOPE=SPFILE; The next example sets a complex initialization parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Creating a Database with the CREATE DATABASE Statement

Step 4: Create the Initialization Parameter FileWhen an Oracle instance starts, it reads an initialization parameter file. This file can be a text … parameter file. In this step, you create a text initialization parameter file. In a later step, you create … a server parameter file from the text file. One way to create the text initialization

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Exporting the Server Parameter Fileinitialization parameter file. Doing so might be necessary for several reasons: For diagnostic purposes … creates a text initialization parameter file from the SPFILE: CREATE PFILE FROM SPFILE; Because no … names were specified for the files, the database creates an initialization parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Managing Initialization Parameters Using a Server Parameter Fileinitialization parameter file. For better manageability, you can choose to maintain initialization … section introduces the server parameter file, and explains how to manage initialization parameters … Storing the Server Parameter File on HARD-Enabled Storage The SPFILE Initialization

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Recovering a Lost or Damaged Server Parameter Fileyou have a valid text initialization parameter file (PFILE), recreate the SPFILE from the PFILE with … If your server parameter file (SPFILE) becomes lost or corrupted, the current instance may fail, or … current values of initialization parameters in memory: CREATE SPFILE FROM MEMORY; This command … a new name

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Storing the Server Parameter File on HARD-Enabled Storagea Release 11 g database, the COMPATIBLE initialization parameter defaults to 11.1.0, so this … text initialization parameter file (PFILE) in the default location with the following single entry … : Create a text initialization parameter file (PFILE) in the default location with the following

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

What Is a Server Parameter File?, by design, a server-side initialization parameter file. Initialization parameters stored in a server … is initially built from a text initialization parameter file using the CREATE SPFILE statement. (It … initialization parameter settings. If no server parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Viewing Parameter Settingsinitialization parameters in the server parameter file (SPFILE). CREATE PFILE This SQL statement creates a text … initialization parameter file (PFILE) from the SPFILE or from the current in-memory settings. You can … initialization parameters in effect for the current session. It is easier to distinguish

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Creating a Server Parameter Filefile (SPFILE) from an existing text initialization parameter file or from memory. Creating the … to the SPFILE. The following example creates a server parameter file from text initialization … message. When you create an SPFILE from a text initialization parameter file, comments specified

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Migrating to a Server Parameter FileIf you are currently using a text initialization parameter file, use the following steps to migrate … to a server parameter file. If the initialization parameter file is located on a client machine … combine all of your instance-specific initialization parameter files

Database Reference, 11g Release 1 (11.1)

Initialization Parameter Descriptions

Initialization Parameter DescriptionsInitialization parameter values apply to the entire database, not to an individual user, unless otherwise … operating system-specific Oracle documentation Press the \"Next\" button to go to the first initialization parameter. … The remainder of this chapter describes the initialization parameters

Database Administrator's Guide, 11g Release 1 (11.1)

Guidelines for Managing Datafiles

Determine a Value for the DB_FILES Initialization ParameterWhen starting an Oracle Database instance, the DB_FILES initialization parameter indicates the … value of DB_FILES (by changing the initialization parameter setting), but the new value does not

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing RMAN Recovery: Advanced Scenarios

Creating an Initialization Parameter File with RMANYou can also restore the server parameter file as a client-side initialization parameter file with … running the instance. The following RMAN command creates an initialization parameter file named /tmp … restart the instance with the initialization parameter file, use

Database Upgrade Guide, 11g Release 1 (11.1)

After Upgrading to the New Release

Set CLUSTER_DATABASE Initialization ParameterIn \"Prepare the New Oracle Home\", you were instructed to set the CLUSTER_DATABASE initializationparameter to false before upgrading a cluster database. Now that the upgrade is finished, you must set this parameter to true.

Database Reference, 11g Release 1 (11.1)

Parameter Files

Initialization Parameter FilesAn initialization parameter file is a text file that contains a list of initialization parameters … in an initialization parameter file: PROCESSES = 100 OPEN_LINKS = 12 GLOBAL_NAMES = true The name of … the initialization parameter file varies depending on the operating

Database Concepts, 11g Release 1 (11.1)

Database and Instance Startup and Shutdown

Initialization Parameter Files and Server Parameter FilesTo start an instance, Oracle Database must read either an initialization parameter file or a server … parameter file. You can also choose to maintain initialization parameters in a server-side binary server … parameter file (SPFI LE). Initialization parameters stored in a server parameter

Database Reference, 11g Release 1 (11.1)

Parameter Files

Specifying Values in an Initialization Parameter FileThis section describes several aspects of setting parameter values in an initialization parameter … file. Rules Governing Initialization Parameter Files The following rules govern the specification of … parameters in initialization parameter files: An initialization

Database Upgrade Guide, 11g Release 1 (11.1)

After Upgrading to the New Release

Migrate Your Initialization Parameter File to a Server Parameter FileIf you are currently using a traditional initialization parameter file, then perform the following … steps to migrate to a server parameter file: If the initialization parameter file is located on a … initialization parameter files into a single initialization

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Duplicating a Database

Step 3: Create an Initialization Parameter File for the Auxiliary InstanceCreate a text-based initialization parameter file for the auxiliary instance. If you are using the … initialization parameter file because you can set these and all other parameters in the DUPLICATE command … set in the initialization parameter file. Table 23-1 describes these initialization

Real Application Clusters Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Understanding the Oracle Real Application Clusters Installed Configuration

6.5 Initialization Parameter FilesOracle recommends using the server parameter file (SPFILE). This file resides on the server on the … shared disk; all instances in a cluster database can access this parameter file. See Also: Chapter 5 … , \" Parameter Management for Oracle Real Application Clusters Databases\" for more information about the creation and use of parameter

Database Installation Guide for Linux, 11g Release 1 (11.1)

Glossary

initialization parameter fileAn ASCII text file that contains information needed to initialize a database and instance.

Real Application Clusters Installation Guide for Linux and UNIX, 11g Release 1 (11.1)

Understanding the Oracle Real Application Clusters Installed Configuration

7.6 Initialization Parameter FilesOracle recommends using the server parameter file (SPFILE). This file resides on the server on the … shared disk; all instances in a cluster database can access this parameter file. See Also: Chapter 6 … , \" Configuring the Server Parameter File in Oracle Real Application Clusters Environments\" for … more information about the