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


Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

About Oracle ASM Initialization Parameter Settings

About Oracle ASM Initialization Parameter SettingsThere are several initialization parameters that you must set for an Oracle ASM instance. You can … parameters use suitable defaults for most environments. You cannot use parameters with names that are prefixed with ASM_* in database instance parameter files.

Database Concepts, 12c Release 1 (12.1)

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

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

About Initialization Parameter Files for an Oracle ASM Instance

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

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.7.5 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 Concepts, 12c Release 1 (12.1)

Oracle Database Instance

Modification of Initialization Parameter Valuesinitialization parameter entry No Yes Modifiable only for the database or instance Yes No Static … value and the old value of an initialization parameter to the alert log. As a preventative measure … Guide to learn how to change initialization parameter settings Oracle Database Reference

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.7.7 Clearing Initialization Parameter ValuesYou can use the ALTER SYSTEM RESET statement to clear (remove) the setting of any initializationparameter in the SPFILE that was used to start the instance. You may want to clear a parameter in the

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.7.6 Changing Initialization Parameter ValuesYou can change initialization parameter values to affect the operation of a database instance … . 2.7.6.1 About Changing Initialization Parameter Values The ALTER SYSTEM statement enables you to set … initialization parameter file, the ALTER SYSTEM statement changes the value of a parameter

Database SQL Tuning Guide, 12c Release 1 (12.1)

Improving Real-World Performance Through Cursor Sharing

CURSOR_SHARING Initialization ParameterThe CURSOR_SHARING initialization parameter controls how the database processes statements with … bind variables. In Oracle Database 12 c, the parameter supports the following values: EXACT This is the

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.6.1 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, 12c Release 1 (12.1)

Using Oracle Managed Files

17.2.2 Setting the DB_CREATE_FILE_DEST Initialization ParameterThe DB_CREATE_FILE_DEST initialization parameter specifies the location of important database files … . Include the DB_CREATE_FILE_DEST initialization parameter in your initialization parameter file to

Automatic Storage Management Administrator's Guide, 12c Release 1 (12.1)

About Backing Up, Copying, and Moving an Oracle ASM Initialization Parameter File

About 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 Reference, 12c Release 1 (12.1)

Initialization Parameter Files

1.3.2 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 Reference, 12c Release 1 (12.1)

Initialization Parameter Descriptions

1.6 Initialization Parameter DescriptionsInitialization parameter values apply to the entire database, not to an individual user, unless otherwise … The remainder of this chapter describes the initialization parameters in alphabetical order

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.4.5 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. Create the initialization

Database Administrator's Guide, 12c Release 1 (12.1)

Creating and Configuring an Oracle Database

2.7 Managing Initialization Parameters Using a Server Parameter Fileinitialization parameter file. For better manageability, you can choose to maintain initializationInitialization parameters for the Oracle Database have traditionally been stored in a text … parameters in a binary server parameter file that is persistent across database startup and shutdown.

Database Reference, 12c Release 1 (12.1)

Rules Governing Initialization Parameter Files

1.3.2.1.1 Rules Governing Initialization Parameter FilesThe following rules govern the specification of parameters in initialization parameter files: An … initialization parameter file should contain only parameters and comments. A pound sign (#) starts a … , \\ SEG3, SEG4, SEG5) You can use the IFILE initialization parameter to embed the

Database Concepts, 12c Release 1 (12.1)

Glossary

initialization parameterinstance. Settings for initialization parameters are stored in a text-based initialization parameter file or binary server parameter file. … A configuration parameter such as DB_NAME or SGA_TARGET that affects the operation of a database

Database Backup and Recovery User's Guide, 12c Release 1 (12.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 … host running the instance. The following RMAN command creates an initialization parameter file named … '; To restart the instance with the initialization parameter file,

Database Reference, 12c Release 1 (12.1)

Specifying Values in an Initialization Parameter File

1.3.2.1 Specifying Values in an Initialization Parameter FileThis section describes several aspects of setting parameter values in an initialization parameter file.

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Space for Schema Objects

You can specify a default system wide timeout interval by setting the RESUMABLE_TIMEOUT initialization…… If the RESUMABLE_TIMEOUT initialization parameter is not set, then the default timeout interval … : \" Setting the RESUMABLE_TIMEOUT Initialization Parameter \" for other methods of changing the timeout interval for resumable space allocation