Results for initialization parameter


1 to 20 of 13202 results. Prev  Next
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





Was this page helpful?

Integrated Cloud Applications & Platform Services