Oracle9i initialization parameters that English
Blank_trimming:
Description: If the value is TRUE, even if the length of the source than the target length (SQL92 compatible) longer, but also allows data distribution.
Range: TRUE | FALSE
Default value: FALSE
serializable:
Description: to determine whether access to query the class to read lock table to prevent the affairs of that contains the query to be submitted to deal with any object before the update to read. This mode of operation to provide repeatable read,
And to ensure that the same kinds of services to deal with the same data to see the two inquiries are the same value.
Range: TRUE | FALSE
Default value: FALSE
row_locking:
Description: specified in the table has been updated or are updating lock when access to lines. If set to ALWAYS, been updated in the table only after the access line lock. If set to INTENT,
Line lock will be used only SELECT FOR UPDATE, but will be updated at lock access table.
Value range: ALWAYS | DEFAULT | INTENT
Default: ALWAYS
shared_servers
Description: Specifies the boot routine, the shared server environment to create the number of server processes.
Range: In accordance with the operating system may be.
Default value: 1
circuits:
Description: can be used to specify inbound and outbound network sessions the total number of virtual circuits. Constitute the parameters of a routine are the total SGA requirements of one of a number of parameters.
Default value: derivative: SESSIONS parameter value (If you are using a shared server architecture); otherwise to 0.
Mts_multiple_listeners:
Description: Specifies the number of listener addresses are specified separately, or with a specified string ADDRESS_LIST. If the value is TRUE,
MTS_LISTENER_ADDRESS parameters can be specified as follows:
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (PORT = 5000) (HOST = zeus))
(ADDRESS = (PROTOCOL = decnet) (OBJECT = outa) (NODE = zeus))
In the 8.1.3 version of this parameter has been abandoned.
Range: TRUE | FALSE
Default value: FALSE
mts_servers:
Description: Specifies the boot routine, the shared server environment to create the number of server processes.
Range: In accordance with the operating system may be.
Default value: 1
mts_service:
Description: a shared server parameters have been used for the designated register at the scheduler,
Used to set up database connection service name only. If you do not want in the case of scheduler can still connect to the database, please set the value to with the same routine. Since this parameter
Version 8.1.3 has been abandoned.
Range: In accordance with the operating system may be.
Default value: 0
mts_sessions:
Description: permit the sharing of the designated server architecture of the total number of user sessions. This parameter can be set up dedicated servers for a number of user session reservations.
Value range: 0 to SESSIONS - 5
Default value: derivative: MTS_CIRCUITS and SESSIONS - 5, whichever is the smaller value
shared_server_sessions:
Description: permit the sharing of the designated server architecture of the total number of user sessions. This parameter can be set up dedicated servers for a number of user session reservations.
Value range: 0 to SESSIONS - 5
Default value: derivative: MTS_CIRCUITS and SESSIONS - 5, whichever is the smaller value
mts_max_dispatchers
Description: specify a shared server environment can run the scheduler at the same time the maximum number of processes.
Range: In accordance with the operating system may be.
Default value: If you have configured the scheduler, the default value of greater than 5 or any number of configurations the number of scheduler
mts_max_servers:
Description: specify a shared server environment can be run simultaneously to share the maximum number of server processes.
Range: In accordance with the operating system may be.
Default value: 20
dispatchers:
Note: In order to set up sharing using shared server environment set up scheduling the amount and type of procedure. Parameters can be specified for some options. For more information,
Please refer to "Oracle8i Administrator's Guide" and "Oracle Net Administrator's Guide". This is an example of string value:
'(PROTOCOL = TCP) (DISPATCHERS = 3)'.
Value range: specify the value of the effective parameters.
Default: NULL
max_shared_servers:
Description: specify a shared server environment can be run simultaneously to share the maximum number of server processes.
Range: In accordance with the operating system may be.
Default value: 20
mts_circuits:
Description: can be used to specify inbound and outbound network sessions the total number of virtual circuits. Constitute the parameters of a routine are the total SGA requirements of one of a number of parameters.
Default value: derivative: SESSIONS parameter value (If you are using a shared server architecture); otherwise to 0.
Mts_listener_address:
Note: Specify the shared server configuration to monitor the procedure. Listener process addresses the need for a monitor in order to deal with the various systems used in network protocol connection request. Unless
MTS_MULTIPLE_LISTENERS = TRUE, otherwise, each entry must have an independent value of the adjacent. This parameter since the 8.1.3 version has been abandoned grammar: (ADDRESS = (PROTOCOL = tcp) (HOST = myhost) (PORT = 7002))
Default: NULL
mts_dispatchers:
Note: In order to set up sharing using shared server environment set up scheduling the amount and type of procedure. Parameters can be specified for some options. For more information,
Please refer to "Oracle8i Administrator's Guide" and "Oracle Net Administrator's Guide". This is an example of string value: '(PROTOCOL = TCP) (DISPATCHERS = 3)'.
Value range: specify the value of the effective parameters.
Default: NULL
max_dispatchers:
Description: specify a shared server environment can run the scheduler at the same time the maximum number of processes.
Range: In accordance with the operating system may be.
Default value: If you have configured the scheduler, the default value of greater than 5 or any number of configurations the number of scheduler
nls_nchar_conv_excp:
Description: (if a value of TRUE) when the loss of implicit data conversion error return parameter.
Range: FALSE | TRUE
Default value: TRUE
nls_numeric_characters:
Description: will be used for the designated group and decimal separator characters. Group separator bit integer is used to separate groups (such as thousands, millions, etc.) characters. Decimal separator used to figure the integer part of a decimal part and separated. Its format is
<decimal_character> <group_separator>.
Value range: Any single-byte characters, '+', '-', '<', '>' except.
Default value: NLS_TERRITORY obtained from
nls_sort:
Description: ORDER BY query specified sequence comparison. For a binary sort, ORDER BY queries is based on comparative sequence-based numerical. For the language to sort,
You need to scan the entire table to the definition of data in accordance with the sort of language to organize.
Value range: BINARY or the definition of effective language.
Default value: NLS_LANGUAGE obtained from
nls_territory:
Note: In order to specify the following naming conventions, including the date and number of weeks, the default date format, the default decimal character and group separator, and the default ISO and local currency symbols. Including the region to support the United States, France and Japan. Information on all regions, please refer to Oracle8i National Language Support Guide.
Value range: any valid name of the region.
Default value: According to the operating system may be
nls_timestamp_format:
Description: with NLS_TIME_FORMAT similar to, but it set the TIMESTAMP data type is the default value, the data type is stored YEAR, MONTH and DAY that some date values stored HOUR, MINUTE and SECOND which some time value.
Syntax: TIMESTAMP'1997-01-31 09:26:50.10 '(the value stored as 11 bytes).
Default value: NLS_TERRITORY obtained from
nls_time_format:
Description: specify a string value, set the default data type TIME value data type that contains the HOUR, MINUTE and SECOND time this some date fields.
Syntax: TIME'09: 26:50 '(the value stored as 7 bytes).
Default value: NLS_TERRITORY obtained from
nls_time_tz_format:
Description: Specifies a pair of values (UTC, TZD), set the TIME WITH TIME ZONE data type of default value, the data type that contains HOUR, MINUTE, SECOND, TIMEZONE_HOUR and date some time this TIMEZONE_MINUTE field. UTC is one of the world sometimes is TZD local time zone.
Syntax: TIME'09: 26:50.20 + 02:00 '(the value stored as 9 bytes).
Default value: NLS_TERRITORY obtained from
nls_length_semantics:
Note: Use byte or code point semantics to specify the creation of the new column, such as char, varchar2, clob, nchar, nvarchar2, nclob out. Various character sets of characters have their own definition. At client and server on the same character set should be based on the character set defined to measure the string of characters. Existing columns will not be affected.
Value range: BYTE or CHAR.
Default: nls_length_semantics the database character set characters in the measurement units used. BYTE.
nls_date_format:
Description: Specifies the TO_CHAR and TO_DATE function with the default date format to use. The default parameters determined by the NLS_TERRITORY. The value of the parameter can be included in the double quotes are any valid date format mask. For example:''MMM / DD / YYYY''.
Value range: any valid date format mask, but not exceeding a fixed length.
Default value: derivative
nls_timestamp_tz_format:
Description: with NLS_TIME_TZ_FORMAT similar to the one of a pair of TIMESTAMP data type value specifies the default value of this type in addition to storage YEAR, MONTH and DAY Date value, HOUR, MINUTE and SECOND time value, but also storage TIMEZONE_HOUR and TIMEZONE_MINUTE.
Syntax: TIMESTAMP'1997-01 - 31 09:26:50 + 02:00 '(the value stored as 13 bytes).
Default value: NLS_TERRITORY obtained from
nls_language:
Description: Specifies the default database language, the language will be used for message, date and month of, AD, BC, AM and PM symbols, as well as the default sort mechanism. Supported languages include English, French and Japanese and so on.
Range: Any valid language name.
Default value: According to the operating system may be
nls_comp:
Description: In the SQL statement, you should avoid using the cumbersome process of NLS_SORT. Under normal circumstances, WHERE clause in the comparison is binary, but the language is required compared NLSSORT function. NLS_COMP can use the designated NLS_SORT session parameters must be based on comparative language.
Value range: Oracle8i National Language Support Guide specified in any valid string of 10 bytes.
Default values: BINARY
nls_currency:
Description: for the L number format element designated for the local currency symbol string. The default parameters determined by the NLS_TERRITORY.
Value range: Oracle8i National Language Support Guide specified in any valid string of 10 bytes.
Default value: NLS_TERRITORY obtained from
nls_date_language:
Note: Specify the date of the spelling, month and date abbreviations (AM, PM, AD, BC) language. The parameters are the default values specified by the NLS_LANGUAGE language.
Value range: any valid value NLS_LANGUAGE.
Default: NLS_LANGUAGE value
nls_dual_currency:
Description: NLS_TERRITORY coverage is defined for the default dual currency symbol. If you do not set the parameters, it will use the default dual currency symbol; otherwise it will launch a dual currency symbol value of the new session.
Range: Any valid format name. .
Default value: double currency symbol
nls_iso_currency:
Description: for the C number format element of the international monetary symbol specified for the string. The default parameters determined by the NLS_TERRITORY.
Value range: any valid value NLS_TERRITORY.
Default value: NLS_TERRITORY obtained from
nls_calendar:
Description: Specifies the Oracle system as the use of what the calendar date format. For example, if NLS_CALENDAR set to 'Japanese Imperial', then the date format for 'E YY-MM-DD'. That is: If date is May 15, 1997, then the SYSDATE is displayed as' H 09-05-15 '.
Value range: Arabic Hijrah, English Hijrah, Gregorian, Japanese Imperial, Persian, ROC Official (Republic of China) and the Thai Buddha.
Default: Gregorian
plsql_native_c_compiler:
Description: earmarked for the generated C file to compile documents for the goal of the C compiler of the full path name. This parameter is optional. With each unique platform attached to make
File contains the default value of this parameter. If specified for this parameter a value, the value will make the document covers the default values.
Value range: C compiler of the full path.
Default value: None
remote_dependencies_mode:
Description: Used to specify a remote database for PL / SQL stored in the course of treatment was dependent on the way the object. If set to TIMESTAMP, only at the server and the local time stamp that matches the circumstances, to perform the process. If set to SIGNATURE, the security situation in the signature can be executed under the process.
Value range: TIMESTAMP | SIGNATURE
Default: TIMESTAMP
utl_file_dir:
Description: Database Administrator permit designated PL / SQL file I / O permission of the directory. The use of multiple parameters can be specified more than UTL_FILE_DIR directory. Please note that all users can read or write UTL_FILE_DIR parameters specified in all documents.
Range: Any valid directory path.
Default value: None
plsql_v2_compatibility:
Description: set up PL / SQL compatibility class. If set to FALSE, the implementation of PL / SQL V3 acts, and does not allow V2 acts; otherwise running PL / SQL V3 will accept certain PL / SQL V2 acts.
Range: TRUE | FALSE
Default value: FALSE
plsql_native_make_utility:
Note: Specify the make utility (such as UNIX's make or gmake, that the GNU make) a complete path name. Generated from C source to generate a shared object or DLL, need to use the make utility.
Value range: make utility of the full path name.
Default value: None
plsql_native_library_dir:
Description: from PL / SQL compiler to use. It specified a directory name, one of the storage of the machine-generated compiler shared object.
The scope of value: the directory name.
Default value: None
plsql_compiler_flags:
Description: from PL / SQL compiler to use. It will compile a list of procedures for signs designated as a comma-separated list of strings.
Value range: native (PL / SQL modules will be compiled to native code.), Interpreted (And PL / SQL module will be built with PL / SQL byte code format), debug (PL / SQL modules will be used to detect debugging symbols to the compiler), non_debug.
Default value: "interpreted, non_debug"
plsql_native_linker:
Description: This parameter specifies the link program (such as: UNIX in the ld, or aim for the file link to a shared object or DLL of the GNU ld) of the complete path name. This parameter is optional. Attached with each platform-specific make file contains the default value of this parameter. If specified for this parameter a value, the value will make the document covers the default values.
Value range: the full path to link the procedure name.
Default value: None
plsql_native_make_file_name:
Description: make the document specified the full path name. make utility (specified by the PLSQL_NATIVE_MAKE_UTILITY) make use of this document to generate a shared object or DLL. Each port has a dedicated platform attached to the make file, which includes the use of make
Utility to generate the DLL on the platform to follow the rules.
Value range: make a complete file path name.
Default value: None
plsql_v2_compatibility:
Description: set up PL / SQL compatibility class. If set to FALSE, the implementation of PL / SQL V3 acts, and does not allow V2 acts; otherwise running PL / SQL V3 will accept certain PL / SQL V2 acts.
Range: TRUE | FALSE
Default value: FALSE
remote_dependencies_mode:
Description: Used to specify a remote database for PL / SQL stored in the course of treatment was dependent on the way the object. If set to TIMESTAMP,
Only at the server and the local time stamp that matches the circumstances, to perform the process. If set to SIGNATURE, the security situation in the signature can be executed under the process.
Value range: TIMESTAMP | SIGNATURE
Default: TIMESTAMP
shared_memory_address:
Description: SHARED_MEMORY_ADDRESS and run-time HI_SHARED_MEMORY_ADDRESS designated SGA starting address. Platform at the time many links SGA starting address specified in this type of platform on these parameters will be ignored. If two parameters are set to 0 or NULL, then the address will be determined in accordance with the platform.
Value Range: any integer value.
Default value: 0
lock_sga:
Description: used to lock the entire SGA in physical memory. Not supported at this function on the platform, the value will be ignored.
Range: TRUE | FALSE
Default value: FALSE
hi_shared_memory_address:
Description: Specifies the system global area (SGA) the start of the run-time address. SGA connection at the designated start address of the platform, the value is ignored. At 64-bit platform, use this value to specify the high 32 and low 32. If you do not specify this value, the default value is specified the location of the platform.
Value Range: any integer value.
Default value: 0
pre_page_sga:
Description: A platform may be based on the parameters, if the parameter is TRUE, all the SGA page will be loaded into memory in order to make the routine to reach the best performance status. This will increase the startup routine and user log in time, but adequate system memory at up to reduce the appearance of missing page fault.
Range: TRUE | FALSE
Default value: FALSE
sga_max_size:
Description: Specifies the routine survival of the system during the occupation of the maximum size of the overall situation.
Value range: 0 to the maximum allowed by the operating system. Please note that because of the minimum value of the parameter value has been adjusted to start at the end, so it does not matter.
Default value: If you do not specify the value, sga_max_size default value will start the initial SGA size (for example, X) the same. SGA depends on the size of the size of various pools, such as buffer cache, shared pool, large pools. If the specified value is less than X, then use the value of sga_max_size for X. In other words, it is X with the user-specified value sga_max_size larger value between the two.
Fast_start_parallel_rollback:
Description: back when the implementation of parallel process to determine the maximum number. In most of the run-time transaction processing systems are longer, the value of very useful.
Range: FALSE | LOW | HIGH
Default value: LOW (2 * CPU_COUNT)
transaction_auditing:
Description: to determine whether the transaction layer generates a special redo record that contains the user login name, user name, session ID, some operating system information, as well as client information. In the use of a redo log analysis tools, these records may be useful.
Range: TRUE | FALSE
Default value: TRUE
transactions:
Description: Specifies the parallel transaction processing the maximum number. If the larger value will increase the size of SGA,
And routines to start the process of increasing the distribution of the number of paragraphs back. The default value is greater than SESSIONS, services to deal with recursive implementation.
Value range: a value.
Default value: derivative (1.1 * SESSIONS)
enqueue_resources:
Description: parallel process to the team can be able to share resources. For example, Oracle allows a process to share a table lock mode to shared mode lock to update another table.
Value range: 10 - 65535 (7.3) or 10 - no restriction (8.1).
Default value: derivative (the value has more than enough DML_LOCKS + 20)
dml_locks:
Note: All user access to the table the maximum number of locks. Table for each DML operation are required to implement a DML lock. For example, if three users to modify tables 2 requires the value of 6.
Value range: 0 or 20 to unlimited.
Default: 4 * TRANSACTIONS (derived)
hash_join_enabled:
Description: If set to TRUE, the optimizer will be calculated at the most effective method of connecting to consider hash link. Oracle data warehouse application recommendations should be used to TRUE value.
Range: TRUE | FALSE
Default value: TRUE
optimizer_features_enable:
Description: permit to change the init.ora parameter controls the optimization of the procedures. Parameters affected include PUSH_JOIN_PREDICATE,
FAST_FULL_SCAN_ENABLED, COMPLEX_VIEW_MERGING and
B_TREE_BITMAP_PLANS.
Value range: 8.0.0; 8.0.3; 8.0.4; 8.1.3.
Default value: 8.0.0
query_rewrite_integrity:
Description: Oracle Server implementation of the degree of query rewriting. If set to ENFORCED, Oracle
Will ensure its consistency and integrity. If set to TRUSTED, will be the relationship between the use of a clear statement to rewrite the permit. If set to
STALE_TOLERATED, even if the materialized view are inconsistent with the basic data, it still can be rewritten.
Value range: ENFORCED, TRUSTED, STALE_TOLERATED
Default: ENFORCED
query_rewrite_enabled
Description: Enable or Disable on the materialized view query rewrite. View of a particular entity only under the following conditions at the opening: session of the parameters and view a separate entity has been opened
And Cost-based optimization is enabled.
Range: TRUE | FALSE
Default value: FALSE
partition_view_enabled:
Description: PARTITION_VIEW_ENABLED If set to TRUE, the optimizer will be cut off (or skip)
Partition table view unnecessary visits. Can change the parameters of the optimization procedure based on the cost of basic table statistics from the calculation of geographical information view statistics information.
Range: TRUE | FALSE
Default value: FALSE
optimizer_max_permutations:
Description: substantial connection with a grammar of the query analysis
Optimization process will take into account a number of restrictions on the exchange table. This helps to ensure that the analysis of grammar queries maintained at an acceptable time limit,
But are unable to find the best price plan. If the value is less than 1000, should be able to query each time to ensure that only a few seconds or less.
Range: 4-2 ^ 32 (~ 4.3 G).
Default value: 80,000
optimizer_index_cost_adj:
Description: too many or too few in considering the path of the index visit, the Optimizer can be used to optimize performance. The lower the value, and optimize the process more easily select an index. In other words,
If you set the value to 50% of the cost of index access path is half of that under normal circumstances.
Value range: 1 -10000
Default value: 100 (an index access path of the conventional cost)
star_transformation_enabled:
Description: Based on the cost of the inquiry to determine whether the conversion will be applied to star queries. If set to TRUE, the optimizer will take into account the cost of conversion will be based on the application of satellite-based query;
If set to FALSE, will not use any conversion; if set to TEMP_DISABLE, inquiries, conversions will be considered, but not the use of temporary tables.
Range: TRUE | FALSE | TEMP_DISABLE
Default value: FALSE
optimizer_mode:
Description: Optimize the specified procedures. If set to RULE, will optimize the use of rule-based process, unless the query contains prompts. If set to CHOOSE,
Will be cost-based optimization procedure, unless the statement of the table does not contain statistical information. ALL_ROWS or FIRST_ROWS
Always use the cost-based optimizer.
Value range: RULE | CHOOSE | FIRST_ROWS | ALL_ROWS
Default: CHOOSE
optimizer_index_caching:
Description: Optimize adjust costs based on the assumption that the value of the procedure,
Buffer cache in the hope of nested loop join for the percentage of the index block. It will affect the use of indexing the cost of nested loop join. The parameter set to a higher value,
Nested loop join can optimize the procedures in relation to lower cost.
Value range: 0 - 100%.
Default value: 0
job_queue_processes:
Description: only for replication environment. It has been designated by the SNP of each routine the number of job queue processes (SNP0, ... SNP9, SNPA, ...
SNPZ). To automatically update the table or the implementation of snapshot DBMS_JOB created by the request, the parameter is set to 1 or greater value.
Range: 0-36
Default value: 0
max_transaction_branches:
Description: Control of Distributed Transaction Processing in the number of branches. Will be set to lower MAX_TRANSACTION_BRANCHES value, based on
MAX_TRANSACTION_BRANCHES * DISTRIBUTED_TRANSACTIONS * 72 bytes,
Slightly reduce the amount of shared pool space. In the 8.1.3 version of this parameter has been abandoned.
Value range: 1 - 32
Default value: 8
compatible:
Description: allows you to use a new release at the same time to ensure that previous versions of backward compatibility.
Value range: The default is the current release.
Default value: determined by the release
archive_lag_target:
Description: This parameter and time-based thread associated with advanced features.
Value range: 0 or [60, 7200] any integer.
Default value: 0 is the default value will be disabled at this point of time based on the advanced features of the thread. Otherwise, the value will represent the number of seconds
aq_tm_processes:
Note: If greater than zero, it will enable the time to monitor the message queue. The time value can be used to specify the delay and failure message property (for application development).
Value range: 0 - 10
Default value: 0
tracefile_identifier:
spfile:
Description: Specifies the current server parameter file name.
Value range: static parameters
Default: SPFILE parameter can be defined in client-side PFILE to indicate the parameters to use the name of the file server. Server using the default server parameter file, SPFILE want the value set by the server in-house.
Logmnr_max_persistent_sessions:
Standby_file_management:
Trace_enabled:
Ifile:
Description: At the current parameters used to document the parameters embedded in other documents. You can file a parameter on the line many times more than the use of the parameters, but can only have three nested.
Value range: any valid file name of the parameter (grammar are IFILE = parameter_file_name).
Default: NULL
remote_listener:
global_context_pool_size:
Description: The distribution from the SGA for storing and managing the overall application environment the amount of memory.
Value Range: any integer value.
Default: 1 M
plsql_native_library_subdir_count:
fixed_date:
Note: SYSDATE return data. Must always return for a fixed date rather than the date of the test system,
This value is useful. Use double quotes, or do not use quotation marks. Do not use single quotation marks.
Values: YYYY-MM-DD-HH24: MI: SS (or the default Oracle date format).
Default: NULL
db_name:
Description: a database identifier with the
CREATE DATABASE statement specified the name of the corresponding.
Value range: any valid name up to 8 characters.
Default value: none (but it should be specified)
cluster_database:
cluster_interconnects:
cluster_database_instances:
sql_version:
replication_dependency_tracking:
Description: Tracking the relevance of the replication server in order to parallel the changes essential to the dissemination. If set to FALSE, the database on the read / write operations to run faster,
However, the server can not have a copy of the relevant parallel information dissemination.
Range: TRUE | FALSE
Default value: TRUE (that is, the opening of read / write correlation tracking)
remote_os_roles:
Description: will REMOTE_OS_ROLES set to TRUE, to allow the remote client machine from the operating system to the role of distribution. If set to FALSE,
From a remote database client to identify and manage roles.
Range: TRUE | FALSE
Default value: FALSE
remote_os_authent:
Description: will REMOTE_OS_AUTHENT set to TRUE, allows the use of OS_AUTHENT_PREFIX
Value to verify the remote client machine.
Range: TRUE | FALSE
Default value: FALSE
open_links:
Description: At the first session the designated open simultaneously with the remote database the maximum number of connections. This value should be equal to or more than one quote more than a single SQL database
Statement cited the number of databases in order to open all database in order to implement the statement.
Value range: 0 - 255 (if it is 0, does not allow the distributed transaction processing).
Default value: 4
open_links_per_instance:
Description: Specifies the XA application can transplant the maximum number of open connections. XA transaction processing using portable open connections,
In order to submit a panel to deal with these connections after the cache. If you create a user is connected to the user has a transaction, the transaction may be shared connection.
Value range: 0 - UB4MAXVAL
Default value: 4
remote_login_passwordfile:
Description: Specifies the operating system or a file to check whether the user has the permissions password. If set to NONE, Oracle will ignore the password file. If set to
EXCLUSIVE, will use the database with a password file for each user to verify. If set to SHARED, a number of database will be shared
SYS and INTERNAL user password file.
Value range: NONE | SHARED | EXCLUSIVE
Default: NONE
hs_autoregister:
Description: Enable or Disable "Heterogeneous Services (HS)" automatic self-registration agent. If enabled, the information will be uploaded to the data dictionary, the
At the same agent in order to follow-up connection set up to reduce costs.
Range: TRUE | FALSE
Default value: TRUE
global_names:
Description: Whether or not the requirements specified by the database link to connect the database with the same name. If the value is FALSE, do not carry out inspections. Distributed to deal with the naming convention consistent,
Please set up the parameters to TRUE.
Range: TRUE | FALSE
Default value: TRUE
distributed_transactions:
Description: A database can participate in a distributed transaction the maximum number of treatment. Abnormal because of a network failure if the frequency and reduce the value, will result in substantial deal with outstanding matters.
Value range: 0 - TRANSACTIONS parameter values.
Default value: According to the operating system may be
commit_point_strength:
Description: A Distributed Transaction is used to determine the location of the point of submitting the value.
Value range: 0 -255
Default value: According to the operating system may be
db_domain:
Note: Specify the database name extension (such as: US.ORACLE.COM) To enable the creation of a database of domain name only, it is recommended that the value specified.
Value range: separated by periods of any string can have up to 128 characters.
Default: WORLD
dblink_encrypt_login:
Description: In the Oracle Server to connect to the other, the database link is the use of encryption password.
Range: TRUE | FALSE
Default value: FALSE
backup_tape_io_slaves:
Description: A Recovery Manager parameters, used to determine whether or not to read or write to tape using a server process, or want an additional I / O slave.
Range: TRUE | FALSE
Default value: FALSE
tape_asynch_io:
Description: on the order of equipment used to control the I / O operation (for example, Oracle data backup or recovery on the tape, or tape backup or recovery
Oracle data) Whether or not asynchronous. Only in your platform supports asynchronous equipment on the order of I / O operating conditions, the value is set to TRUE
To be valid; if the asynchronous I / O implementation of the unstable, please set the value to FALSE.
Range: TRUE | FALSE
Default value: FALSE
log_file_name_convert:
Description: the master database log file on a file name into a standby database on an equal footing on the path and file name. A log file will be added to a master database, the
Must be a corresponding file to the standby database. The parameters of the Oracle7 alternative LOG_FILE_NAME_CONVERT
Parameters.
Value range:''in any format for the main log file path / file names''and''back-up log file path / filename''effective path / file name
Default: NULL
fal_server:
Description: Specifies the standby database server FAL. The value is an Oracle Net service name. The Oracle Net
Services were assumed to have been right on the standby database system configuration, can point to the desired FAL server.
Value range: Oracle Net service name of the string value.
Fal_client:
Description: FAL designated for services (through FAL_SERVER configuration parameters) to invoke the FAL client FAL
Customer name. The value of the parameter is an Oracle Net service name. Oracle Net service name for this is presumed to have been at FAL
Right on the server system configuration, can point to FAL client (ie: This standby database).
Value range: Oracle Net service name of the string value.
Drs_start:
Description: so that Oracle can determine whether it should start the process of DRMON. DRMON is a fatal error will cause the Oracle background process,
Exist as long as the routine, the process exist.
Range: TRUE | FALSE.
Default value: FALSE
remote_archive_enable:
Description: Whether or not to control the implementation of long-range goal archived redo log files to operate. The parameter values must be set to "TRUE", so that Oracle
Routine database redo log files for remote archiving, and / or to receive remote archiving of redo log files.
Range: FALSE | TRUE
Default value: TRUE
standby_preserves_names:
Description: indicates that the database backup on the file name with the main database on the same file name.
Range: TRUE or FALSE. Note: If the value is set to True, and the standby database with the master database is located on the same system, then the main database file may be overwritten.
Default: FALSE.
Standby_archive_dest:
Description: designated from a main routine of the arrival of the archive log location. STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT
On standby at the location for virtual fully qualified name of the archive log file. The RFS on the standby database server will use the value, rather than
ARCHIVE_LOG_DEST.
Value range: NULL string or RAW types of effective path / device name.
Default: NULL
db_file_name_convert:
Description: the main database on a new data file is converted to the file name on the standby database filename.
Range: an effective master / backup directory and file name right.
Default value: None
max_enable_roles:
Description: Users can designate a role in opening the database (including sub-roles) the maximum number. Users can enable the role of the 2 are combined with the actual quantity
MAX_ENABLED_ROLES value, because each user has two additional roles: PUBLIC and the user's own role.
Value range: 0 -148
Default value: 20
O7_DICTIONARY_ACCESSIBILITY:
Description: mainly used for transplantation from Oracle7 to Oracle8i. If the value is TRUE, SYSTEM privileges (such as
SELECT ANY TABLE) would not limit the SYS program of the visit of the object (Oracle7 behavior). If the value of
FALSE, only to be granted SELECT_CATALOG_ROLE, EXECUTE_CATALOG_ROLE or
DELETE_CATALOG_ROLE permissions to access the SYS user of the object program.
Range: TRUE | FALSE
Default value: TRUE
sql92_security:
Note: To specify a reference to update or delete the value shown in the table with the required form of the class
SELECT permission.
Range: TRUE | FALSE
Default value: FALSE
audit_trail:
Description: enable or disable database auditing. If the parameter is TRUE or DB, audit records will be written into the SYS.AUD $ table; if the parameters for the OS,
Then write an operating system file.
Value range: NONE | FALSE | DB | TRUE | OS
Default: NONE
rdbms_server_dn:
Description: RDBMS servers were the only judge. It is used in an enterprise directory service to retrieve the role of enterprises. For more information, please see "Oracle
Advanced Security Administrator's Guide ".
Value range: Unique identification of all the X.500 format value.
Default value: None
os_roles:
Description: the operating system or database to determine whether the role for each user ID. If set to TRUE, the operating system will be fully managed database of all users granted the role. Otherwise,
Role identification and management of the database will be.
Range: TRUE | FALSE
Default value: FALSE
os_authent_prefix:
Note: Use the user's operating system account name and password to authenticate users to connect to the server. The value of the parameter with the user's operating system account to connect together. OS account to remove the prefix,
Please specify the null value.
Value range: Any identifier.
Default value: According to the operating system of the (usually 'OPS $')
object_cache_max_size_percent:
Description: Specifies the session object cache can grow more than the best percentage of cache size,
Best equal the size of the largest size with the size of the percentage of the product with the best. If the cache size exceeds this maximum size,
System will try to reduce the cache size to the best.
Value range: 0% to the operating system may be based on the Maximum.
Default value: 10%
object_cache_optimal_size:
Description: Specifies the cache size exceeds the maximum, the session object cache will be reduced to size.
Value range: 10K to be based on the maximum operating system.
Default: 100K
session_max_open_files:
Description: can be specified at any given session to open the maximum number of BFILE. Once this quantity,
Since then the conversation will not be able to open more documents. This parameter also depends on the operating system parameters MAX_OPEN_FILES.
Value range: 1 - at least (50, OS on the class MAX_OPEN_FILES).
Default value: 10
parallel_execution_message_size:
Note: Specify parallel execution (parallel query, PDML, restore and replication in parallel) the size of the message. If the value is greater than 2048 or 4096,
On the need for greater shared pool. If PARALLEL_AUTOMATIC_TUNING = TRUE,
Will be outside the storage pool in the designated message buffer.
Value range: 2148 - infinity.
Default values: If PARALLEL_AUTOMATIC_TUNING to FALSE, usually a value of 2148; PARALLEL_AUTOMATIC_TUNING as if TRUE, the value of 4096 (according to the operating system may be).
Paralle_min_percent:
Description: Parallel implementation of the requirements specified minimum percentage of the thread. Setting the parameters to ensure that parallel execution can be used in the absence of appropriate subordinate to the process of inquiry, it will display an error message,
And that the inquiry will be not implemented.
Value range: 0 -100
Default values: 0, indicated that he did not use the parameter.
Parallel_automatic_tuning:
Description: If set to TRUE, Oracle will control the parallel execution parameters to determine the default value. In addition to setting the parameters,
For the system you must also set up tables in parallel.
Range: TRUE | FALSE
Default value: FALSE
parallel_threads_per_cpu:
Description: Description of a CPU in the parallel implementation of the process or to deal with the number of threads,
And optimize parallel adaptive algorithms and load balancing algorithm. If your computer is in the implementation of a typical query has the signs of overload, the value should be reduced.
Value range: Any non-zero value.
Default: determined in accordance with the operating system (usually 2)
parallel_broadcast_enabled:
Description: By using a hash or merge link connection can be a number of large result sets will be connected to a small result set (in bytes rather than acts to measure the size of units)
Improve performance. If the value is set to TRUE, the optimizer can be a small result set of each line set to spread to large-scale database clusters for each line of treatment.
Range: TRUE | FALSE
Default value: FALSE
parallel_adaptive_multi_user:
Description: enable or disable an adaptive algorithm designed to enhance the use of parallel implementation of the performance of multi-user environment. Adopted by the system automatically reduces the load of requests for degree of parallelism,
Inquiries at start implementation of this feature. When PARALLEL_AUTOMATIC_TUNING = TRUE when its best.
Range: TRUE | FALSE
Default values: If PARALLEL_AUTOMATIC_TUNING = TRUE, then the value is TRUE; otherwise FALSE
parallel_max_servers:
Description: Parallel routine to specify a server or a parallel implementation of the maximum number of restore process. If necessary, the routine starts the query server's distribution will increase the number of quantity.
Value range: 0 -256
Default value: from CPU_COUNT, PARALLEL_AUTOMATIC_TUNING and determine PARALLEL_ADAPTIVE_MULTI_USER
parallel_min_servers
Description: designated as the startup routine after the parallel execution, Oracle server processes the query to create the smallest quantity.
Value range: 0 - PARALLEL_MAX_SERVERS.
Default value: 0
log_archive_dest_state_3:
Note: Specify the archive log parameters (only LOG_ARCHIVE_DEST_3) availability status. If this is enabled,
Goal will be archiving the log. If the delay, the goal will be excluded from the archiving operations until re-opening of the outside.
Range: ENABLE | DEFER
Default values: ENABLE
log_archive_dest_state_4:
Note: Specify the archive log parameters (only LOG_ARCHIVE_DEST_4) availability status. If this is enabled,
Goal will be archiving the log. If the delay, the goal will be excluded from the archiving operations until re-opening of the outside.
Range: ENABLE | DEFER
Default values: ENABLE
log_archive_dest_state_5:
Note: Specify the archive log parameters (only LOG_ARCHIVE_DEST_5) availability status. If this is enabled,
Goal will be archiving the log. If the delay, the goal will be excluded from the archiving operations until re-opening of the outside.
Range: ENABLE | DEFER
Default values: ENABLE
log_archive_dest_state_6:
Description: identify a specific goal of the recent log archive of user-defined status.
Range: ENABLE - effective if the target property, the goal the opening of archive log; DEFER - even if the goal of effective property, but also delay the treatment goal archive log; or ALTERNATE - archive log aim delayed treatment until the failure of another goal cause of this goal is automatically enabled (provided that the reserve goal of the property must be valid).
log_archive_dest_state_7:
Description: identify a specific goal of the recent log archive of user-defined status.
Range: ENABLE - effective if the target property, the goal the opening of archive log; DEFER - even if the goal of effective property, but also delay the treatment goal archive log; or ALTERNATE - archive log aim delayed treatment until the failure of another goal cause of this goal is automatically enabled (provided that the reserve goal of the property must be valid).
log_archive_dest_state_8:
Description: identify a specific goal of the recent log archive of user-defined status.
Range: ENABLE - effective if the target property, the goal the opening of archive log; DEFER - even if the goal of effective property, but also delay the treatment goal archive log; or ALTERNATE - archive log aim delayed treatment until the failure of another goal cause of this goal is automatically enabled (provided that the reserve goal of the property must be valid).
log_archive_dest_state_9:
Description: identify a specific goal of the recent log archive of user-defined status.
Range: ENABLE - effective if the target property, the goal the opening of archive log; DEFER - even if the goal of effective property, but also delay the treatment goal archive log; or ALTERNATE - archive log aim delayed treatment until the failure of another goal cause of this goal is automatically enabled (provided that the reserve goal of the property must be valid).
Log_archive_start:
Note: n in the database only in the "archive log" mode applies. It specified redo log is automatically or manually copy the. Recommended value is TRUE, that is, the implementation of automatic archiving;
Otherwise, it required manual intervention, the use of
ALTER SYSTEM ARCHIVE LOG ... order to prevent hang routines.
Range: TRUE | FALSE
Default value: FALSE
log_archive_duplex_dest:
Description: LOG_ARCHIVE_DEST outside the designated filing another goal. At Oracle8i Enterprise Edition, the parameters are
LOG_ARCHIVE_DEST_n replace.
Value range: A NULL string or any valid path or device name, except the original partition.
Default: NULL
log_archive_format:
Description: LOG_ARCHIVE_FORMAT only in the database is in "Archive Log" mode useful in the case. Text string with the variable% s (log sequence number)
And% t (thread number) used in combination, is used to specify the archive redo log files the only file names. The string was attached to
LOG_ARCHIVE_DEST parameters.
Value range: any valid file name.
Default value: According to the operating system may be
log_archive_max_processes:
Note: Specify the required number of ARCH process. If LOG_ARCHIVE_START = TRUE, the value can be evaluated at startup routines;
Can also, through SQL * Plus or SQL syntax ARCH process called assessment.
Value range: 1 - 10 (including endpoints) to any integer.
Default value: 1
log_archive_dest_2:
Description: The five local (designated LOCATION) or remote (designated SERVICE) goal in the second position,
Archived redo log files can be up at the location of these targets being copied. This parameter only oracle8i Database Enterprise Edition or higher version of the database effectively.
Value range: grammar for (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer]
Default: NULL
log_archive_min_succeed_dest:
Note: the definition of coverage in the log file before copy it to the goal of a minimum quantity. This value should be greater than or equal to LOG_ARCHIVE_DEST_n Medium
The number of MANDATORY goal.
Value range: 1 - 5 (if LOG_ARCHIVE_DEST and share LOG_ARCHIVE_DUPLEX_DEST, they are restricted at 1-2).
Default value: 1
log_archive_trace:
Description: control the process of archiving the log output generated. This process can be activated through
Backgrounds ARCn process (in the log output is designated as ARCn)
Specific conversation Front Desk call process (in the output log designated as ARCH) or
"Managed standby database" of the remote file server (RFS) process.
Value range:
0: disable the archive log to track (This is the default setting)
1: follow-up redo log files archived
2: The goal of each archived log archive status tracking
4: Tracking archiving operational phase
8: archive logs to track activity goal
16: Tracking a detailed archive log activity goal
32: follow-up archive log parameters modified
64: ARCn the process of tracking activity status
Default value: 0
log_archive_dest_10:
log_archive_dest_3:
Description: The five local (designated LOCATION) or remote (designated SERVICE) goal in the third position,
Archived redo log files can be up at the location of these targets being copied. This parameter only oracle8i Database Enterprise Edition or higher version of the database effectively.
Value range: grammar for (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer]
Default: NULL
log_archive_dest:
Description: The five local (designated LOCATION) or remote (designated SERVICE) goal in the third position,
Archived redo log files can be up at the location of these targets being copied. This parameter only oracle8i Database Enterprise Edition or higher version of the database effectively.
Value range: grammar for (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer]
Default: NULL
log_archive_dest_state_2:
Note: Specify the archive log parameters (only LOG_ARCHIVE_DEST_2) availability status. If this is enabled,
Goal will be archiving the log. If the delay, the goal will be excluded from the archiving operations until re-opening of the outside.
Range: ENABLE | DEFER
Default values: ENABLE
log_archive_dest_5:
Description: The five local (designated LOCATION) or remote (designated SERVICE) goal in the fifth position,
Archived redo log files can be up at the location of these targets being copied. This parameter only oracle8i Database Enterprise Edition or higher version of the database effectively.
Value range: grammar for (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer]
Default: NULL
log_archive_dest_6:
log_archive_dest_1:
log_archive_dest_8:
log_archive_dest_9:
log_archive_dest_state_1:
Note: Specify the archive log parameters (only LOG_ARCHIVE_DEST_1) availability status. If this is enabled,
Goal will be archiving the log. If the delay, the goal will be excluded from the archiving operations until re-opening of the outside.
Range: ENABLE | DEFER
Default values: ENABLE
log_archive_dest_state_10
Description: The goal specified archive log.
Value range: the local file system location (the location of the disk) or through the Oracle Net service name (tns Service) designated by the location of the remote archive. :
log_archive_dest_4:
Description: The five local (designated LOCATION) or remote (designated SERVICE) goal in the fourth position,
Archived redo log files can be up at the location of these targets being copied. This parameter only oracle8i Database Enterprise Edition or higher version of the database effectively.
Value range: grammar for (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer]
Default: NULL
create_bitmap_area_size:
Description: CREATE_BITMAP_AREA_SIZE designated for the creation of bitmap indexing and distribution of memory capacity.
Range: In accordance with the operating system may be.
Default: 8 MB
pga_aggregate_target:
Description: Specifies the routine to connect to the goal of all server process PGA memory total. Automatically set in the opening of the work area before you set this parameter to a positive number. This part of memory does not reside in
Medium SGA. Database used for this parameter value of the goal it uses the volume of PGA memory. Set this parameter can be used to SGA from Oracle
Routine by subtracting the total system memory. And the remaining amount of memory can be allocated to the pga_aggregate_target.
Range: integer add the letters K, M or G, to this limit is designated as kilobytes, megabytes or gigabytes. The minimum is 10M, Maximum for the 4000G
Default value: "not specified", said the ban completely the use of automatic optimization of the work area.
Sort_area_size:
Description: SORT_AREA_SIZE in bytes, specify the sort used by the largest amount of memory. Sort is completed, all will be back,
And memory will be released. Increase the value to increase the efficiency of large-scale sequencing. If more than the amount of memory will be above the use of temporary disk.
Value range: the equivalent of six database block value (minimum) to the operating system to determine the value of (Maximum).
Default value: According to the operating system may be
sort_area_retained_size
Description: in bytes, specified in a sort of running after the user to retain the overall area (UGA) of the Maximum amount of memory. The last line was from the sort of space after extraction,
The memory will be released back to UGA, but not released to the operating system.
Value range: from the equivalent value of the two databases to block SORT_AREA_SIZE value.
Default: SORT_AREA_SIZE value
bitmap_merge_area_size:
Description: Specifies the index of the merger from a range of scanning and retrieval of digital map to be the amount of memory to be used.
Value range: According to system.
Default: 1MB
workarea_size_policy:
Description: the size of the designated work area adjust strategy. Optimization of this parameter to control the work area where the model.
Range: AUTO, MANUAL.
Default: If set PGA_AGGREGATE_TARGET, compared AUTO; otherwise MANUAL.
Hash_area_size:
Description: with parallel DML or DDL operations and related statements. It is in bytes, specify the connection to be used for hashing the largest amount of memory. For more information,
Please refer to the manual Oracle8i Concepts.
Value range: 0 to be in accordance with the value of the operating system.
Default value: derivative: 2 * SORT_AREA_SIZE parameter values
db_create_online_log_dest_4:
Description: set up an online log created and control the default file location. If you create an online log or control file does not specify a file name, then use the default file name.
Value range: the file system directory name. The directory must already exist. The directory must have at one of Oracle can create a file permission.
db_create_online_log_dest_3:
Description: set up an online log created and control the default file location. If you create an online log or control file does not specify a file name, then use the default file name.
Value range: the file system directory name. The directory must already exist. The directory must have at one of Oracle can create a file permission.
Db_files:
Note: You can open the database the maximum number of data files.
Value range: MAXDATAFILES - determined in accordance with the operating system.
Default value: According to the operating system may be (in the Solaris system for the 200)
db_create_online_log_dest_2:
Description: set up an online log created and control the default file location. If you create an online log or control file does not specify a file name, then use the default file name.
Value range: the file system directory name. The directory must already exist. The directory must have at one of Oracle can create a file permission.
db_create_online_log_dest_1:
Description: set up an online log created and control the default file location. If you create an online log or control file does not specify a file name, then use the default file name.
Value range: the file system directory name. The directory must already exist. The directory must have at one of Oracle can create a file permission.
Db_create_file_dest:
Description: Set the created data files, control files and online logs of the default location.
Value range: the file system directory name. The directory must already exist. The directory must have at one of Oracle can create a file permission.
Control_files:
Description: Specify one or more control file name. Oracle recommended for different device or OS image using multiple document files.
Value range: 1 - 8 file name (with path names).
Default value: According to the operating system may be
db_create_online_log_dest_5:
Description: set up an online log created and control the default file location. If you create an online log or control file does not specify a file name, then use the default file name.
Value range: the file system directory name. The directory must already exist. The directory must have at one of Oracle can create a file permission.
Large_pool_size:
Note: Specify the distribution of a large pool heap size, it can be used for shared server session memory, parallel execution for message buffers, as well as for RMAN
Backup and restore disk I / O buffer.
Value range: 600K (minimum);> = 20000M (Maximum are determined in accordance with the operating system).
Default values: 0, unless parallel execution or configured DBWR_IO_SLAVES
shared_pool_size:
Description: in bytes, specify the size of shared pool. Such as shared pool contains: cursor sharing, storage, process,
And parallel control structures such as the implementation of message buffer object. Larger values can improve the performance of multi-user systems.
Value range: 300 KB - determined in accordance with the operating system.
Default value: If it is 64-bit operating system, a value of 64MB; other cases, the value of 16MB.
Java_pool_size:
Description: in bytes, specify the Java memory pool size, it used to store Java method and class definition in the shared memory of that law,
And call at the end of the conversation migrated to Java object Java space. For more information, please refer to Oracle8i Java
Developer's Guide.
Range: In accordance with the operating system may be.
Default value: According to the operating system may be
shared_pool_reserved_size:
Description: want to specify a larger memory requests for shared pool reserved space,
In order to avoid debris caused by the decline in performance. The size of the pool should be in accordance with such conditions: the object can be stored to prevent the update from the shared pool and common requirements of all major process and package.
Value range: SHARED_POOL_RESERVED_MIN_ALLOC to
SHARED_POOL_SIZE half (bytes).
Default: SHARED_POOL_SIZE value 5%
cursor_sharing:
Description: Control can be shared to share the same termination of the cursor types of SQL statements.
Value range:
Mandatory: mandatory sentences to express meaning in different ways the same but share a cursor statement.
EXACT: the only identical SQL statements to share a cursor.
Default: EXACT
open_cursors:
Note: the designation of a conversation can open a cursor (environment area) the largest quantity, and limit the PL / SQL used in PL / SQL
The size of the cursor cache, to avoid the statement again when the user re-analysis of grammar. Please set the value high enough,
Application in order to prevent depletion of the cursor open.
Value range: 1 - operating system limit.
Default value: 64
serial_reuse:
Description: Specifies what type of SQL cursors should make use of serial memory function reusable. If CURSOR_SPACE_FOR_TIME = TRUE,
SERIAL_REUSE values will then be ignored, as is set to
DISABLE or NULL handle the situation.
Value range: DISABLE | SELECT | DML | PLSQL | ALL | NULL
Default: NULL
session_cached_cursors:
Description: Specify the session cache the number of the cursor. On the same SQL statement many times grammar analysis,
Cursor of the conversation it will be moved to the session cursor cache. This will shorten the time for the analysis of grammar, because the cursor cache was no need to be re-opened.
Value range: 0 to be in accordance with the value of the operating system.
Default value: 0
cursor_space_for_time:
Note: the cursor in a shared SQL areas cited, determined to remain in the Shared SQL area from the pool or by treatment expired.
Range: TRUE | FALSE
Default: FALSE (expired)
rollback_segments:
Description: designated to start the process of routine access to one or more Rollback segment, even if the quantity more than TRANSACTIONS /
TRANSACTIONS_PER_ROLLBACK_SEGMENT value. The formula for ROLLBACK_SEGMENTS =
(rbseg_name [, rbseg_name] ...)
Value range: In addition to SYSTEM outside, DBA_ROLLBACK_SEGS listed in paragraph any rollback.
Default: NULL (default Rollback segment to use the public)
undo_suppress_errors:
Description: At SMU mode allows the user to try to implement RBU operations (such as
ALTER ROLLBACK SEGMENT ONLINE) ignoring the error. This will enable users of all applications and script to switch to SMU
SMU before a pattern of features to use.
Range: True or False
Default value: False.
Max_rollback_segments:
Description: Medium designated SGA cache Rollback segment size of the largest. The numerical designation of a routine that can be online at the same time maintaining the status (that is for status INUSE)
Rollback segment of the largest quantity.
Range: 2 -65535
Default value: Maximum (30, TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT)
undo_retention:
Description: UNDO_RETENTION
Parameters used to specify the database to retain the information has been submitted to the total amount of the withdrawal. Startup routine can be set at the parameter values. Can be calculated to meet the requirements of the withdrawal of reservations to withdraw the amount of space:
UndoSpace = RD * UPS, one of UndoSpace to block withdrawal of the number of express, RD for the second unit
UNDO_RETENTION to express, UPS few per second to indicate the block to withdraw.
Value range: the maximum allowed for the (2 ** 32) second.
Default value: 30 seconds.
Transactions_per_rollback_segment:
Description: Rollback segment designated for each of the permit the number of parallel transaction processing. Start of the Rollback segment to obtain the minimum number of TRANSACTIONS
Parameter value divided by the result. If the named parameter in the other ROLLBACK_SEGMENTS Rollback segment, you can access these Rollback segment.
Value range: 1 - In accordance with the operating system may be.
Default value: 5
undo_management:
Description: Specifies the system should either withdraw the use of space management. If set to AUTO, the routine will be SMU mode. Otherwise will be RBU mode. At
RBU mode, undo space will be back as the same paragraph at the external distribution. At SMU mode, undo space as the undo tablespace will be the same as at the external distribution.
Range: AUTO or MANUAL
Default values: If the first start, when neglect of routine UNDO_MANAGEMENT parameters will use the default value of MANUAL, and routines will be RBU mode. If this is not the first routine will be activated by other existing routines used to start the withdrawal mode routines.
Undo_tablespace:
Description: undo tablespace used to store undo information only. UNDO_TABLESPACE only permit withdrawn in the system management (SMU)
Mode. Routine will be used to withdraw the specified table space, <undoname>. If the table space does not exist, or table space is not withdrawn,
Or are being used by another routine, the routine will fail STARTUP.
Default value: Each database contains 0 or more undo tablespace. At SMU mode, for each distribution of a routine ORACLE (and only one) undo tablespace.
Instance_name
Note: use the same routine in a number of cases of Services to uniquely identify a database routines. INSTANCE_NAME should not be confused with the SID,
It is in fact at a host of shared memory on the unique identifier in all routines.
Value range: Any alphanumeric characters.
Default value: database SID
service_names:
Description: Oracle Net listener is used to identify a service (such as: copy of a specific environment database)
The routine specified service name. If the service is not the domain will be DB_DOMAIN additional parameters.
Grammar: SERVICE_NAMES = name1.domain, name2.domain
Default: DB_NAME.DB_DOMAIN (if defined)
local_listener:
Description: a list of Oracle Net addresses for Oracle Net logo
Where the listener on the same computer database routines. Scheduling of all routine procedures and monitoring procedures on the register in order to enable the client to connect. The parameters of coverage at
Version 8.1 and MTS_LISTENER_ADDRESS abandoned MTS_MULTIPLE_LISTENERS parameters.
Range: A valid Oracle Net address list.
Default: (ADDRESS_LIST = (Address = (Protocol = TCP) (Host = localhost) (Port = 1521)) (Address = (Protocol = IPC) (Key = DBname)))
license_sessions_warning:
Description: Specifies the number of concurrent user sessions warning limit. After that limit is reached, other users can still connect, but an ALERT message will be written into the document. With
RESTRICTED SESSION users will receive a warning message that the system is near maximum capacity.
Value range: 0 - LICENSE_MAX_SESSIONS
Default value: 0
license_max_sessions:
Description: designated permit concurrent users at the same time the maximum number of sessions. After that limit is reached only with RESTRICTED SESSION
Users can connect to the server. All other users will receive a warning message that the system has reached maximum capacity restrictions.
Value range: 0 - number of session licenses.
Default value: 0
license_max_users:
Description:
You can specify the database to create the maximum number of users. Parallel session and user licensing should not be permitted to use the opening at the same time. LICENSE_MAX_SESSIONS
Or LICENSE_MAX_USERS or both, the value should be zero.
Value range: 0 - number of user license.
Default value: 0
db_block_checksum:
Description: DBWn, ARCH and SQL * loader Whether or not the data for each block read or write or checksum calculation of the checksum block.
Range: TRUE | FALSE
Default value: FALSE
shadow_core_dump:
Description: One of the parameters for UNIX, SGA is used to specify whether or not to dump information to a core file generated. If set to FULL, SGA
Will be included in the core dump. If set to PARTIAL, SGA will not be dump.
Value range: FULL | PARTIAL
Default: FULL
db_block_checking:
Description: Whether or not used to control transaction processing to check whether the damaged block management.
Range: TRUE | FALSE
Default value: FALSE
background_core_dump:
Description: Whether or not the SGA information to a dump file generated by the core (for UNIX).
Value range: FULL | PARTIAL
Default: FULL
event:
Description: from the use of Oracle technical support personnel to debug the system. Under normal circumstances, should not change the value.
Value range: not available.
Default value: None
user_dump_dest:
Description: for the server process will be a user identity in one of the trace file into the debug directory of the specified path name. For example, the directory can be set up to do: NT operating system on the C: /
ORACLE / UTRC; UNIX operating system on the / oracle / utrc; or VMS operating system on the
DISK $ UR3: [ORACLE.UTRC].
Range: A valid local pathname, directory, or disk.
Default value: According to the operating system may be
timed_statistics:
Description: The time to collect the operating system information, such information can be used to optimize the database and the SQL statement. To prevent the request from the operating system time overhead caused by,
Please set the value to zero. Set the value to TRUE for a long time to view the progress of the operation is also useful.
Range: TRUE | FALSE
Default value: FALSE
timed_os_statistics:
Description: by the system administrators to collect statistical information on the operating system. For efficient use of resources only when needed to provide the value. For dedicated servers,
Users will be connected and disconnected from the pop-up call (if it exceeded the time limit specified), the operating system to gather statistical information. For shared server,
Will pop into or call the collection of statistical information.
Value range: The second time as a unit.
Default value: 0 (operating system statistics are not broke)
core_dump_dest:
Description: Specifies the location of the core dump directory name (for UNIX).
Range: Any valid directory name.
Default: ORACLE_HOME / dbs
oracle_trace_collection_name:
Description: Oracle Trace collection name specified in the output file name to use (the definition of a document collection. Cdf and data collection documents
. dat). If the parameter is empty, and ORACLE_TRACE_ENABLE = TRUE, it will start a default
Oracle Trace collection, once again until the value is set to NULL.
Range: an effective collection name, up to 16 characters (eight characters using a platform other than the file name).
Default: NULL
oracle_trace_collection_path:
Note: Specify the Oracle Trace collection definition file (. Cdf) and data collection file (. Dat) where the directory path name.
Value range: a complete directory path name.
Default value: According to the operating system may be (usually the ORACLE_HOME / otrace / admin / cdf)
background_dump_dest:
Description: Specifies the operation for the Oracle background processes (LGWR, DBW n and so on) into the trace file path name
(Directory, or disk). It also recorded an important case definition and warning message database file.
Range: Any valid directory name.
Default: ORACLE_HOME / rdbms / log (determined in accordance with the operating system)
oracle_trace_enable:
Description: To enable Oracle Trace collection of server, please set the value to TRUE. If set to TRUE, the server can use
Oracle Trace. To start a collection process for ORACLE_TRACE_COLLECTION_NAME
Designate a non-empty value; or use the Oracle Trace Manager to start a collection.
Range: TRUE | FALSE
Default value: FALSE
oracle_trace_collection_size:
Description: in bytes, Oracle Trace collection file specified maximum size. Once the size of the collection of documents to achieve this maximum,
Collection will be disabled. Zero if the specified range, it means there is no size limit.
Value range: 0 -4294967295
Default value: 5242880
oracle_trace_facility_path:
Note: Specify the Oracle TRACE instrument definition file (. Fdf) where the directory path name.
Value range: a complete directory path name.
Default: ORACLE_HOME / otrace / admin / fdf / (depending on your operating system may be)
sql_trace:
Description: Disable or enable the SQL tracking devices. If set to TRUE, will be optimized to collect information useful to improve performance. Because of the use of SQL
Tracking devices will lead to system overhead, it should only be in the information necessary to optimize the use of TRUE.
Range: TRUE | FALSE
Default value: FALSE
oracle_trace_facility_name:
Description: Oracle Trace product definition specified file name (. Fdf file name). This file contains for the use of Oracle Trace
API data collection products to collect all of the case definition and data information. Oracle recommend using the default file ORCLED.FDF.
Range: an effective device name, up to 16 characters.
Default: oracled
max_dump_file_size:
Description: Specifies the maximum of each trace file size. If you are concerned about trace file will take up too much space and may be changed by the restrictions. Dump file can be achieved if the maximum allowable size of the operating system,
Please specify the value as "unlimited."
Value range: 0 - unlimited (can use 'K' or 'M' as a unit)
Default value: 10,000
resource_limit:
Description: to determine whether a summary of the document in the database implementation of resource constraints. If set to FALSE, the resource constraints will be disabled. If the value is TRUE, ie opening of the resource constraints.
Range: TRUE | FALSE
Default value: FALSE
resource_manager_plan:
Description: If you specify this value, resource management plans and will activate all the sub-routine items (sub-plans, instructions and user group). If you do not specify, the resource manager will be disabled,
However, the use of
ALTER SYSTEM command can also be enabled.
Range: Any valid string.
Default: NULL
sessions:
Description: Specifies the user session and systems of the total session. The default quantity is greater than PROCESSES, to allow recursive conversation.
Value Range: any integer value.
Default value: derivative (1.1 * PROCESSES + 5)
java_soft_sessionspace_limit:
Description: in bytes, specified in Java using the Java session memory 'soft constraints'. If the duration of the user's session Java
Status of the use of too much memory, Oracle will generate a warning to the trace file to write a message.
Value range: 0 - 4GB
Default value: 0
cpu_count:
Note: Oracle of the number of available CPU (used to calculate the other parameter values). Do not change the value.
Value range: 0 - unlimited.
Default value: automatically set by Oracle
java_max_sessionspace_size:
Description: in bytes, specified for the server running Java program used by the largest amount of memory. Database used to store each time it calls the Java
State . If the duration of the user's session Java state exceeds the value, the conversation will be terminated because of insufficient memory.
Range: In accordance with the operating system may be.
Default value: 0
processes:
Description: At the same time designated to connect to an Oracle Server process on the operating system, the maximum number of users. This value should be allowed to carry out all the background processes, such as:
Job queue (SNP) and parallel implementation of the process (Pnnn) process.
Value range: 6 to operating system may be based on a value.
Default value: PARALLEL_MAX_SERVERS determined by
control_file_record_keep_time:
Description: control file could be re-used parts of the records must be retained in the shortest time (days).
Value range: 0 -365
Default value: 7
log_checkpoint_timeout:
Note: a check from the designated point of maximum time interval (seconds). The time value is designated as 0,
Will be disabled in order to time-based checkpoints. A lower value can shorten recovery time routine, but it may cause excessive disk operations.
Value range: 0 - unlimited.
Default: Oracle8i: 900 second. Enterprise Edition: 1800 seconds
recovery_parallelism:
Description: Specifies the media to participate in routine or the number of restore process. If the value is 0 or 1, it means that a process will be to restore the serial manner.
Range: In accordance with the operating system may be (should not exceed PARALLEL_MAX_SERVERS).
Default value: According to the operating system may be
fast_start_mttr_target:
Description: Specifies the database from a single routine in the collapse of the time required to restore (the estimated number of seconds). FAST_START_MTTR_TARGET
Will be converted to in-house a set of parameters, to modify the operation of the database in order to restore its control in the total time "the average time to restore (MTTR)"
The scope of the must. Only a "Quick Start Fault Recovery" version features support for this parameter.
Value range: [0, 3600]. It will calculate the data buffer cache entries above, and log more than the maximum number of block limits.
Default value: 0
log_checkpoints_to_alert:
Description: check points will be assigned to the early warning information document records. The parameters for determining whether the requirements of checkpoint frequency useful.
Range: TRUE | FALSE
Default value: FALSE
fast_start_io_target:
Description: Specifies the system crash or during routine restore the required I / O quantity. The value DB_BLOCK_MAX_DIRTY_TARGET
Recovery process for more precise control.
Value range: 0 (disable I / O Recovery restriction), or 1000, to cache all of the buffer number.
Default value: all the cache buffer in the number of
log_checkpoint_interval:
Description: At designated checkpoints before there must be written into the redo log files in the OS block (rather than the database block) of the quantity. No matter how this value,
At log switch checkpoint will occur. A lower value can shorten the time required to restore routine, but it may cause excessive disk operations.
Range: unlimited (0 to disable the specified parameters).
Default value: According to the operating system may be
log_buffer:
Description: in bytes, specified in the LGWR to write redo log entries before the redo log files,
Cache these entries for the amount of memory. Redo entries in the database block to retain a record of the change. If the value is greater than 65536, you can reduce the redo log file I /
O, there is a long time especially in the affairs or deal with a large number of transaction processing systems.
Range: In accordance with the operating system may be.
Default value: Maximum for the 500K or 128K * CPU_COUNT, whichever is the greater access
read_only_open_delayed:
Description: used to accelerate some operations, such as: a great database to start one of the most data is stored on read-only table space. If set to TRUE,
Read from the table space data will be the first to visit the read-only table space data file. Of the possible side-effects, see the Server Reference
manual.
Range: TRUE | FALSE
Default value: FALSE
parallel_instance_group
Description: a cluster database parameters, logo used to generate a large number of concurrent parallel execution routine group affiliation. Parallel operation only in its INSTANCE_GROUPS
Parameter to specify a matching group produced a large number of parallel execution routine subordination.
Value range: a representative group of the string.
Default value: all the current composition of the group of routine activity
parallel_server:
Description: will PARALLEL_SERVER set to TRUE, the database cluster option can be enabled.
Range: TRUE | FALSE
Default value: FALSE
parallel_server_instances:
Description: The routine is currently the number of configurations. SGA is used to determine the structure of its size, the structure of the routine configured to determine the quantity. Setting the right parameters will improve the SGA
Memory usage. Some have used the number of parameters are calculated.
Value range: Any non-zero value.
Default value: 1
thread:
Description: a cluster database parameters for the routines for each assigned a unique number of the redo thread. Redo thread in the routine is disabled,
The routine can not start. If the value is zero, this indicates that there is a common thread is enabled to choose from.
Value range: 0 - has enabled the maximum number of threads.
Default value: 0
gc_files_to_locks:
Description: a cluster database parameters will be used to control parallel cache management (PCM) lock is mapped to the data files.
Grammar: GC_FILES_TO_LOCKS = 'file_list = lock_count [! Blocks] [R] [EACH ][:...]'
Default: NULL
instance_number:
Description: a cluster database parameters used to specify a unique number to the routine use of mapping to a FREELIST GROUPS
Storage parameters to create the database objects owned by the free list. At
ALTER TABLE ... the INSTANCE value of the use of the clause. ALLOCATE EXTENT
Statement can be dynamically allocated area of the routine.
Value range: 1 to MAX_INSTANCES (to create the database specified).
Default value: the smallest number of available (depending on the order of startup routine and other routines INSTANCE_NUMBER specified value)
active_instance_count:
Description: two routines in the permit constitutes a cluster of a routine designated as the main routine, and the other for the sub-routine routine. If the cluster contains more than two of the routines,
This parameter has no effect.
Value range: 1 or> = set of routines in the number of clusters.
Default value: None
lock_name_space:
Description: Specifies the Distributed Lock Manager (DLM) used to generate lock names namespace. If a cluster with the same name on there is a backup database or clone database
Set the value of the best.
Value range: there is a maximum of eight characters, special characters are not allowed.
Default: NULL
max_commit_propagation_delay:
Description: a cluster database parameters for the SGA to designate a routine included in the system change number (SCN) has been set before LGWR,
Permit to retain most of the time (to 1 / 100 seconds). This is a very small change of the performance parameters required, because SCN
Will not be possible based on the time to refresh.
Value range: 0 - 90000
Default value: 700
instance_groups:
Description: a cluster database parameters, you can use a comma-separated list,
The current routine is assigned to a specific group. Distribution for the parallel query slave process to operate when used in routine group.
Value range: a series of group names, separated by commas.
Default: NULL
buffer_pool_recycle:
Description: cycle pool size (from DB_BLOCK_BUFFERS distribution). The purpose is to use the object after its removal in order to re-use memory.
Value range: a specific string value (for example: buffers: 50, lru_latches: 1).
Default value: None
use_indirect_data_buffers:
Description: Control can support more than 4GB of physical memory of 32-bit platform for the expansion of the buffer cache on the use of mechanisms. In other platforms, this parameter will be ignored.
Range: TRUE | FALSE
Default value: FALSE
disk_asynch_io:
Description: Control of data files, control files and log files of the I / O is asynchronous (that is, in the table in the process of scanning process is overlap I / O and CPU
Request). Only in your platform supports asynchronous disk I / O in order to change the circumstances of the parameters.
Range: TRUE | FALSE
Default value: TRUE
dbwr_io_slaves:
Description: DBW0 the process of using the I / O quantity subordinate. Process and its subordinate DBW0 always write to the disk.
Value range: 0 - In accordance with the operating system may be.
Default value: 0
db_8k_cache_size:
Description: Specifies the size of cache for 8K buffers. Only db_block_size at 8K when the value is not in order to set this parameter.
Value range: 0M, or at least 16M. The value of block size to satisfy the specific requirements of a specific platform.
Default: 0M
db_4k_cache_size:
Description: Specifies the size of cache for 4K buffers. Db_block_size only when the value is not 4K in order to set this parameter.
Value range: 0M, or at least 16M. The value of block size to satisfy the specific requirements of a specific platform.
Default: 0M
db_block_buffers:
Description: buffer cache Oracle block the number. This parameter will be a significant impact on the total size of SGA routine.
Value range: 4 - may be in accordance with the operating system.
Default value: 32768
db_32k_cache_size:
Description: Specifies the size of cache for 32K buffers. Only db_block_size at 32K when the value is not in order to set this parameter.
Value range: 0M, or at least 16M. The value of block size to satisfy the specific requirements of a specific platform.
Default: 0M
db_block_size:
Description: an Oracle database block size (bytes). The value set in the creation of the database, but can not be changed thereafter.
Value range: 1024 - 65536 (depending on your operating system may be).
Default value: 2048 (based on the operating system may be)
db_cache_advice:
Description: for a variety of capacity is expected to conduct cache enable and disable the collection of statistical information. V $ DB_CACHE_ADVICE view at the collection of information.
Value range: OFF - turn off the consultation and does not allocate memory for the advisory; ON - Open consultative (ie: will lead to CPU and memory overhead); READY - turn off the consultation, but to retain the memory allocated to the advisory.
Default value: OFF
db_2k_cache_size:
Description: Specifies the size of cache for 2K buffers. Db_block_size only when the value is not 2K in order to set this parameter.
Value range: 0M, or at least 16M. The value of block size to satisfy the specific requirements of a specific platform.
Default: 0M
db_cache_size:
Note: In order to specify the standard block cache buffer size.
Range: At least 16M.
Default: 48M
db_16k_cache_size:
Description: Specifies the size of cache for 16K buffers. Only db_block_size at 16K when the value is not in order to set this parameter.
Value range: 0M, or at least 16M. The value of block size to satisfy the specific requirements of a specific platform.
Default: 0M
db_file_multiblock_read_count:
Description: At a fully involved in a continuous scanning I / O operation to read the maximum number of the block.
Range: In accordance with the operating system may be.
Default value: 8
db_keep_cache_size:
Description: KEEP buffer pool specified number of the buffer zone. KEEP buffer pool size is the size of the main block (ie db_block_size
The definition of block size).
Value range: 0 or at least one block size (a smaller value will be automatically rounded up to block size).
Default: 0M
db_recycle_cache_size:
Description: Specifies the size of the RECYCLE buffer pool. RECYCLE buffer pool size is the size of the main block.
Value range: 0 or at least one block size (a smaller value will be automatically rounded up to block size).
Default: 0M
db_writer_processes:
Description: Writing a routine process in the initial database quantity. If you are using a DBWR_IO_SLAVES, only the use of a database write process.
Value range: 1 - 10
Default value: 1
buffer_pool_keep:
Description: reservation pool size (from DB_BLOCK_BUFFERS distribution). The aim is to retain objects in memory to reduce I / O.
Value range: a particular string value (for example: buffers: 400, lru_latches: 3).
Default value: None
Related Posts of Oracle9i initialization parameters that English
-
Through the v $ parameter to check initialization parameters
rn Many people through the v $ parameter to find the source of initialization parameters lost her way. There are two reasons, first, the nature of the hidden deep Oracle; First, our understanding of the Oracle not go far enough. rn We should follow t ...
-
Oracle Database initialization parameter changes to note
Generally only in large-scale application or performance data, according to the Treasury decreased only need to change the initialization parameters. So from this perspective, the adjustment of parameters to initialize Oracle database is a high-level ...
-
OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ adjustment
Recent production system on the oracle 9i database cluster parameters have been adjusted. Mainly includes two parameters: OPTIMIZER_INDEX_CACHING this initialization parameter represents a percentage range from 0 to 99. The default value is 0, repres ...
-
Oracle database system parameters (including hidden and abandoned)
Oracle database system based initialization parameter file init.ora parameters set to configure their own startup, each instance starts, first read the parameter file to set the different parameters. Oracle system parameters, according to the system ...
-
The new initialization parameters
SQL> show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- compatible string 11.2.0.0.0 Parameters related to memory ● automatic memory management features SGA and the PGA automa ...
-
oracle books
From the Internet to find a set of Oracle9i Database Fundamentals I and the Oracle9i Database Fundamentals Ⅱ English books, and the U.S. share common study. Books from the Internet, thanks to the author! PDF format is. Document: Oracle9i Database Fun ...
-
RMAN said, I can back up (6) - RMAN backup of a backup set of initialization parameters and
8.3.6 initialization parameter file Backup Usually, when the backup control file, RMAN will automatically back up the server-side initialization parameter file, and placed in the same backup control file fragments, so little need for a separate backu ...
-
oracle initialization parameter file
1 WINDOWS 2000 under the examples: Parameter file record data instance configuration parameters (such as the System Global Area SGA), the data buffer, the log buffer and some non-default parameters; its storage path:% ORACLE% \ Admin \% SID% \ pfile ...
-
linux install oracle9i Chinese garbled Solutions
rnrnrnrnrnrnrnrnrnrn linux install oracle9i Chinese garbled Solutions rnrnrnrn rn rn rn Oracle on Linux, installed when the characters are the "mouth" shape garbled the first time is rather tense in English can only be installed and after r ...
-
Computer programmers how to master English
Dry programmer is a very hard work, to be particularly difficult in a high-level programmer. This is because the computer software technology updates at an increasing rate, because these technologies are mostly from English-speaking countries, we hav ...
Leave a Reply