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 20 of 15841 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

Changing Initialization Parameter Valuesinitialization parameters. If you are using a text initialization parameter file, the ALTER SYSTEM statement … Changing Initialization Parameter Values Use the SET clause of the ALTER SYSTEM statement to set or … change initialization parameter values. The optional SCOPE

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

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 2 (11.2)

Creating and Configuring an Oracle Database

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 2 (11.2)

Creating and Configuring an Oracle Database

About Initialization Parameters and Initialization Parameter FilesWhen an Oracle instance starts, it reads initialization parameters from an initialization parameter … values. The initialization parameter file can be either a read-only text file, a PFILE, or a read … with a text initialization parameter file. Upon startup, the Oracle

Database Administrator's Guide, 11g Release 2 (11.2)

Using 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 2 (11.2)

Creating and Configuring an Oracle Database

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 … the COMPATIBLE initialization parameter. If you do, there is no way to start the database

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Instances

Initialization Parameter Files for an Oracle ASM InstanceSPFILE or a text-based initialization parameter file (PFILE) as the Oracle ASM instance parameter … search order that apply to database initialization parameter files also apply to Oracle ASM … initialization parameter files. When an Oracle ASM instance searches for

Database Administrator's Guide, 11g Release 2 (11.2)

Creating and Configuring an Oracle Database

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 Reference, 11g Release 2 (11.2)

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 2 (11.2)

Creating and Configuring an Oracle Database

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 … The SPFILE Initialization Parameter Changing Initialization

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Instances

Backing Up, Copying, and Moving an Oracle ASM Initialization Parameter FileDatabase Administrator's Guide for more information about creating and maintaining initializationparameter files Oracle Database SQL Language Reference for information about creating an SPFILE with the

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

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 … host running the instance. The following RMAN command creates an initialization parameter file named … '; To restart the instance with the initialization parameter file,

Database Concepts, 11g Release 2 (11.2)

Oracle Database Instance

Text Initialization Parameter FilesA text initialization parameter file is a text file that contains a list of initialization … text initialization parameter file is text-based, not binary. Oracle Database can read but not … write to the text initialization parameter file. To change the parameter

Database Reference, 11g Release 2 (11.2)

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 2 (11.2)

Oracle Database Instance

Modification of Initialization Parameter ValuesFigure 13-7 Multiple Initialization Parameter Files Description of \"Figure 13-7 Multiple … Initialization Parameter Files\" See Also: Oracle Database Administrator's Guide to learn more about text … initialization parameter files Oracle Database SQL Language Reference to learn about

Database Performance Tuning Guide, 11g Release 2 (11.2)

Configuring and Using Memory

Table 7-5 Values for the RESULT_CACHE_MODE Initialization Parameterchanges to the results. You can set the RESULT_CACHE_MODE initialization parameter for the instance … Database Reference to learn about the RESULT_CACHE_MODE initialization parameter 7.6.3.2 Using SQL … RESULT_CACHE_MODE initialization parameter is set to FORCE or the RESULT_CACHE hint

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Duplicating a Database: Advanced Topics

Table 25-4 Initialization Parameter Restrictions for Oracle Managed FilesInitialization Parameter Purpose Restriction CONTROL_FILES Specifies one or more names of control … backup is available), then you can create a temporary initialization parameter file on the destination … initialization parameter file on the destination host and set only the DB_NAME

Database Reference, 11g Release 2 (11.2)

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 Security Guide, 11g Release 2 (11.2)

Verifying Security Access with Auditing

Table 9-1 AUDIT_TRAIL Initialization Parameter Settingsinitialization parameter. You do not need to set AUDIT_TRAIL to enable either fine-grained auditing or SYS … setting for the AUDIT_TRAIL parameter. If the database was started in read-only mode with AUDIT_TRAIL set … following additional initialization parameters: AUDIT_FILE_DEST, which specifies the location of the