Blank_trimming: Description: If the value is True, even if the source length is longer than the target length (SQL92 compatible), it is also allowed to allocate data. Value Range: True | False Default: False Serializable: Description: Determine if the query gets the read lock of the table-level to prevent any object read before being submitted in transaction processing that contains the query. This mode of operation provides repeatable reading and ensures that the same value is the same value for two queries of the same data in the same transaction. Value range: True | False Default: false row_locking: Description: Specifies whether to get a line lock when the table has been updated or being updated. If set to always, only the line lock is obtained after the table is updated. If set to INTENT, only the row lock will be used for SELECT for Update, but the table lock will be obtained when updating. Value range: Always | Default | INTENT Default: ALWAYS Shared_Servers Description: Specify the number of server processes created for the shared server environment after the startup routine. Value range: Depending on the operating system. Default: 1 Circuits: Description: Specifies the total number of virtual circuits available for inbound and outbound network sessions. This parameter is one of several parameters that constitute the total SGA requirements of a routine. Default: Derife: The value of the sessions parameter (if you are using the shared server architecture); otherwise 0. MTS_MULTIPLE_LISTENERS: Description: Specifies the address of multiple listeners to specify separately, or specifies with an Address_List string. If this value is true, the MTS_Listener_Address parameter can be specified as: (address_list = (address = (protocol = tcp) (Host = Zeus)) (ADDRESS = (Protocol = Decnet) (bDE = Zeus) This parameter has been discarded in version 8.1.3. Value: true | false default: false mts_servers: Description: Specify the number of server processes created for the shared server environment after the startup routine : Depending on the operating system. Default: 1 MTS_Service: Description: A shared server parameter, used to specify a unique service name that has been registered on the scheduler to establish a database connection. If you want to have no scheduler Connect to the database, set this value to the same name. This parameter has been discarded from the 8.1.3 version. Value range: Default: 0 MTS_SESSIONS: Description: Specify the allowed shared server The total number of architecture user sessions. Set this parameter to keep some user sessions for private servers. Values: 0 to sessions - 5 Default: Derife: MTS_CIRCUITS and SESSSIONS - 5 Small-5 Shared_Server_SESSIONS: Description: Specify Allow The shared server architecture user session is the total number. Set this parameter to keep some user sessions for the dedicated server. Value range: 0 to sessions - 5 Default: Derife: MTS_CIRCUITS and SESSIONS - 5 MTS_MAX_DISPATCHERS Description: Specifies the maximum number of scheduling program processes that can run simultaneously in a shared server environment. Value range: Depending on the operating system. Default: If the scheduler is configured, the default value is any number or configuration of the default value or configuration. Machine MTS_MAX_SERVERS: Description: Specifies the maximum number of shared server processes that can run simultaneously in a shared server environment. Value range: Depending on the operating system.
Default: 20 Dispatcher: Description: Set the number and type of the scheduler for setting the shared server using the shared server. Several options can be specified for this parameter. For more information, see "Oracle8i Administrator Guide" and "Oracle Net Administrator's Guide". This is an example of a string value: '(protocol = TCP) (Dispatchers = 3)'. Value range: Valid specified value for parameters. Default: null max_shared_servers: Description: Specifies the maximum number of shared server processes that can run simultaneously in a shared server environment. Value range: Depending on the operating system. Default: 20 MTS_CIRCUITS: Description: Specifies the total number of virtual circuits available for inbound and outbound network sessions. This parameter is one of several parameters that constitute the total SGA requirements of a routine. Default: Derife: The value of the sessions parameter (if you are using the shared server architecture); otherwise 0. MTS_Listener_Address: Description: Specifies the listener configuration of the shared server. The listener process requires a listening address to handle the connection requests for the various network protocols used in the system. Each entry must have an independent neighbor value unless MTS_MULTIPLE_LISTENERS = TRUE. This parameter has been abandoned in the 8.1.3: (address = (protocol = TCP) (host = = tcp) (port = 7002)) Default: NULL MTS_DISPATCHERS: Description: Set the dispatch to set the shared server using the shared server The quantity and type of the program. Several options can be specified for this parameter. For more information, see "Oracle8i Administrator Guide" and "Oracle Net Administrator's Guide". This is an example of a string value: '(protocol = TCP) (Dispatchers = 3)'. Value range: Valid specified value for parameters. Default: null max_dispatcher: Description: Specifies the maximum number of scheduler processes that can run simultaneously in a shared server environment. Value range: Depending on the operating system. Default: If the scheduler has been configured, the default value is any number or the number of schedulers for any number or configuration of the configured scheduler NLS_NCHAR_CONV_EXCP: (if value true) returns an error parameter when the data is lost in implicit conversion. Value range: false | True Default: True NLS_NUMERIC_CHARACTERS: Description: Specifies the characters that will be used as group separators and decigrants. The component isolation is a character used to separate a plurality of groups (such as thousands, millions, etc.). The decimal separator is used to separate a number of integers into the decimal portion. The format is
For information on all regions, see Oracle8i National Language Support Guide. Value range: Any valid area name. Default: Depending on the operating system, NLS_TimeStamp_Format: Description: Similar to NLS_Time_Format, only it sets the default value of the TimeStamp data type, which stores Year, Month and Day, also store HOUR, Minute Several time values for SECOND. Syntax: TimeStamp '1997-01-31 09: 26: 50.10' (stored in 11 bytes). Default: NLS_TIME_FORMAT from NLS_TERRITORY: Description: Specify a string value, set the default value of the TIME data type, which contains Hour, Minute, and Second's datetime fields. Syntax: Time '09: 26: 50 '(stores the value to 7 bytes). Default: NLS_TIME_TZ_FORMAT: Description: Specify a pair of values (UTC, TZD), set the default value of the Time with time zone data type, which contains Hour, Minute, Second, Timezone_Hour and Timezone_minute these Date Time Field. UTC is the world and TZD is the local time zone. Syntax: Time '09: 26: 50.20 02:00 '(stored in 9 bytes). Default: NLS_LENGTH_SEMANTICS: Description: Use byte or code point semantics to specify the creation of the new column, such as Char, Varchar2, Clob, Nchar, NVARCHAR2, NCLOB column. Various character sets have their own definitions. When using the same character set on the client and server, the string should be measured at the character set. Existing columns will not be affected. Value range: byte or char. Default: NLS_LENGTH_SEMANTICS's database character set of metric units. Byte. NLS_DATE_FORMAT: Description: Specifies the default date format used to use with the to_CHAR and TO_DATE functions. The default value of this parameter is determined by NLS_TERRITORY. The value of this parameter can be any valid date format mask included in the double quotation number. For example: '' MMM / DD / YYYY ''. Value range: Any valid date format mask, but must not exceed a fixed length. Default: Derife NLS_TimeStamp_tz_Format: Description: Similar to NLS_Time_tz_Format, one of the pair of values specifies the default value of the TimeStamp data type, which stores Year, Month and Day date values, Hour, Minute, and Second time values, also store Timezone_Hour and Timezone_minute . Syntax: TimeStamp '1997- 01-31 09: 26: 50 02:00' (stored as 13 bytes). Default: NLS_LANGUAGE: Description: Specify the default language of the database, the language will be used for the symbol of messages, date, and month name, AD, BC, AM, and PM, and the default sorting mechanism. Supported languages include English, French and Japanese, and more. Value range: Any valid language name. Default: Depending on the operating system, NLS_COMP: Description: In the SQL statement, you should avoid the use of a cumbersome NLS_SORT process.
Under normal circumstances, the comparison in the WHERE clause is binary, but the language comparison requires the NLSSort function. You can use NLS_COMP to specify that you must perform a language according to NLS_SORT session parameters. Value range: Any valid 10-byte string specified in Oracle8i National Language Support Guide. Default: binary nls_currency: Description: Specifies a string used as a local currency symbol for the L number format element. The default value of this parameter is determined by NLS_TERRITORY. Value range: Any valid 10-byte string specified in Oracle8i National Language Support Guide. Default: NLS_DATE_LANGUAGE: Description: Specify the language of spelling date name, month name, and date antennas (AM, PM, AD, BC). The default value of this parameter is the language specified by NLS_LANGUAGE. Value range: Any valid NLS_LANGUAGE value. Default: NLS_LANGUAGE NLS_DUAL_CURRENCY: Description: Used to override the default dual currency symbol defined in NLS_TERRITORY. If this parameter is not set, the default dual currency symbol will be used; otherwise a new session of a value is a double currency symbol. Value range: Any valid format name. . Default: Double currency symbol NLS_ISO_CURRENCY: Description: Specifies the string used as an international currency symbol for the C digital format element. The default value of this parameter is determined by NLS_TERRITORY. Value range: Any valid NLS_TERRITORY value. Default: NLS_CALENDAR in NLS_TERRITORY: Description: Specifies which calendar system to specify oracle as the date format. For example, if the NLS_CALENDAR is set to 'Japanese Imperial', the date format is 'e yy-mm-dd'. That is: If the date is May 15, 1997, SYSDATE is displayed as 'h 09-05-15'. Value range: Arabic Hijrah, ENGLISH HIJRAH, GREGORIAN, JAPANESE IMPERIAL, PERSIAN, ROC OFFICOAL (Republic of China) and Thai Buddha. Default: Gregorian PLSQL_NATIVE_C_Compiler: Description: Specifies the full path name for compiling the generated C file as the target file. This parameter is optional. The default value of this parameter is included in the unique Make file included with each platform. If a value is specified for this parameter, the value will override the default value in the Make file. Value range: The full path to the C compiler. Default: No remote_dependencies_mode: Description: The process of specifying the database for remote PL / SQL storage is dependent on the object. If set to TimeSTAMP, the process can only be performed only if the server matches the local timestamp. If set to signature, the process can be executed in the case of signing security. Value Range: TimeStamp | Signature Default: TimeStamp UTL_FILE_DIR: Description: Allows the database administrator to specify the directory of the PL / SQL file I / O license. Use multiple UTL_FILE_DIR parameters to specify multiple directories. Please note that all users can read or write all files specified in the UTL_FILE_DIR parameter. Value range: Any valid directory path. Default: No PLSQL_V2_COMPATIBILILILILILILILILILILITY: Sets the PL / SQL compatibility.
If set to false, PL / SQL V3 behavior will be executed without allowing V2 behavior; otherwise certain PL / SQL V2 behavior will be accepted when running PL / SQL V3. Value Range: True | False Default: false plsql_native_make_utility: Description: Specify the full path name of the make utility (such as Make or Gmake, Gnu Make in UNIX). To generate a shared object or DLL from the generated C source, you need to use the Make utility. Value Range: The full path name of the make utility. Default: No PLSQL_NATIVE_LIBRARY_DIR: Description: Use the PL / SQL compiler. It specifies the directory name, which stores the shared object generated by the machine compiler. Range value: Directory name. Default: No PLSQL_Compiler_Flags: Description: Use the PL / SQL compiler. It specifies the compiler flag list as a list of strings separated by commas. Value range: native (PL / SQL module will compile.), Interpreted (then PL / SQL module will be compiled into a PL / SQL byte code format), Debug (PL / SQL module will use probe debug symbol To compile), Non_Debug. Default: "Interpreted, Non_debug" PLSQL_NATIVE_LINKER: Description: This parameter specifies the full path name of the link (such as: LD in UNIX, or Linked target file to the GNU LD of the Shared Object or DLL). This parameter is optional. The default value of this parameter is included in the unique Make file included with each platform. If a value is specified for this parameter, the value will override the default value in the Make file. Value range: The full path name of the link program. Default: No PLSQL_NATIVE_MAKE_FILE_NAME: Description: Specifies the full path name of the make file. The Make utility (specified by PLSQL_NATIVE_MAKE_UTILITY) uses this MAKE file to generate a shared object or DLL. Each platform is attached to a port-specific Make file that contains rules that use the Make utility to generate a DLL on that platform. Value range: The full path name of the make file. Default: No PLSQL_V2_COMPATIBILILILILILILILILILILITY: Sets the PL / SQL compatibility. If set to false, PL / SQL V3 behavior will be executed without allowing V2 behavior; otherwise certain PL / SQL V2 behavior will be accepted when running PL / SQL V3. Value Range: True | FALSE Default: false remote_dependencies_mode: Description: The process of specifying a database for remote PL / SQL storage is dependent on the object. If set to TimeSTAMP, the process can only be performed only if the server matches the local timestamp. If set to signature, the process can be executed in the case of signing security. Value Range: TimeStamp | Signature Default: TimeStamp Shared_Memory_Address: Description: Shared_Memory_address and hi_shared_memory_address Specifies the starting address of the running SGA. Many platforms specify the SGA start address in the link time, which will be ignored on such platforms. If the two parameters are set to 0 or NULL, the address will depend on the platform. Value range: Any integer value. Default: 0 LOCK_SGA: Description: Used to lock the entire SGA in physical memory. This value will be ignored on a platform that does not support this function.
Value Range: True | False Default: false hi_shared_memory_address: Description: Specifies the runtime starting address of the system global zone (SGA). This value is ignored on the platform of the start address when specifying the SGA connection. On the 64-bit platform, use this value to specify a high 32-bit and low 32 bits. If this value is not specified, the default value is the location specified in the platform. Value range: Any integer value. Default: 0 pre_page_sga: Description: A parameter set according to the platform, if this parameter is TRUE, all SGA pages will be loaded into memory so that the routine will quickly reach the optimal performance. This will increase the time of routine startup and user login, but can reduce the occurrence of the fault failure on the system of sufficient memory. Value range: True | FALSE Default: False SGA_MAX_SIZE: Description: The maximum size of the system's global zone occupied by the specified routine survival. Value range: 0 to the maximum allowed by each operating system. Please note that because the minimum value of the parameter value has been adjusted at startup, it has nothing to do. Default: If the value is not specified, the default value of SGA_MAX_SIZE will be the same as the initial size (such as X) of the SGA at startup. This size depends on the size of various pools in the SGA, such as buffer cache, sharing pool, large pool, etc. If the specified value is less than X, the value of the SGA_MAX_SIZE used will be X. That is, it is a larger value between the X and the user specified by the user. Fast_start_parallel_rollback: Description: Perform the maximum number of processes to perform parallel return. This value is useful on the system where most transaction processing is running. Value range: false | Low | High Default: Low (2 * CPU_Count) Transaction_auditing: Description: Determine whether the transaction layer generates a special redo record, which contains the user login name, user name, session ID, partial operating system information And client information. These records may be useful when using a redo log analysis tool. Value range: True | False Default: True Transactions: Description: Specifies the maximum number of parallel transactions. If this value is set large, the size of the SGA will be added, and the number of retire segments assigned during the routine startup process can be added. The default is greater than Sessions to implement recursive transaction processing. Value range: a value. Default: Delivery (1.1 * sessions) enqueue_resources: Description: The entry allows the parallel process to share resources. For example, Oracle allows a process to lock a table in sharing mode to lock another table in sharing update mode. Value range: 10 - 65535 (7.3) or 10 - no limit (8.1). Default: Derife (this value is greater than DML_LOCKS 20) DML_LOCKS: Description: The maximum number of table locks acquired by all users. One DML lock is required for performing DML operations for each table. For example, if the three users modify 2 tables, the value is required to be 6. Value range: 0 or 20 to unlimited. Default: 4 * Transactions Hash_JOIN_ENABED: Description: If set to TRUE, the optimizer will consider the hash linkage when calculating the most efficient join method. Oracle recommends that the data warehouse application should use the TRUE value. Value Range: True | False Default: True Optimizer_FeatureS_Nable: Description: Allows the init.ra parameter, which controls the behavior of the optimizer. The parameters affected by this include push_join_predicate, fast_full_scan_enabled, complex_view_merge, and b_tree_bitmap_plans. Value range: 8.0.0; 8.0.3; 8.0.4; 8.1.3.
Default: 8.0.0 query_rewrite_integrity: Description: The extent of the query override executed by Oracle Server. If set to Enforces, Oracle will guarantee its consistency and integrity. If you are set to trusted, you will use a clear declaration to allow rewrite. If you are set to Stale_Tolerate, you can still rewrite even if the physicalized view is inconsistent with the base data. Value range: Enforced, Trusted, Stale_tolerated default: Enforced Query_rewrite_enabled Description: Enable or disable the query override to the physicalized view. A specific physicalized view is enabled only under the following conditions: session parameters and individual physicalized views are enabled, and the cost-based optimization is enabled. Value range: true | false default: false partition_view_enabled: Description: If you set partition_view_enabled to True, the optimizer will cut (or skip) unnecessary table access in the partition view. This parameter can also change the way to calculate partition view statistics from the basic list statistics based optimization program. Value Range: True | False Default: false Optimizer_max_permutations: Description: When you analyze a query with a large number of join, the optimizer will consider the number of restrictions. This helps ensure that the time of syntax analysis of the query is maintained within an acceptable restriction, but the cost cannot find the best plan. If this value is less than 1000, you should ensure that each query is only for a few seconds or less. Value range: 4-2 ^ 32 (~ 4.3 g). Default: 80,000 Optimizer_index_cost_adj: Description: Optimize the performance of the optimizer in consideration of too much or too little index access path. The lower the value, the easier the optimizer is easier to select an index. That is, if this value is set to 50%, the cost of the index access path is half of normal conditions. Value range: 1 -10000 Default: 100 (General Cost of an Index Access Path) Star_Transformation_enabled: Description: Determine whether the cost-based query conversion will be applied to a star query. If set to True, the optimizer will consider using cost-based conversions in the star query; if set to false, will not use any conversion; if set to TEMP_DISABLE, consider query conversion, but do not use a temporary table. Value range: true | false | TEMP_DISABLE Default: false Optimizer_Mode: Description: Specifies the behavior of the optimizer. If set to rule, a rule-based optimization program will be used unless the query contains a prompt. If set to Choose, a cost-based optimization program is used, unless the table in the statement does not contain statistics. All_rows or first_rows always use cost-based optimization programs. Value range: rule | choose | first_rows | all_rows default: choose optimizer_index_caching: Description: Adjust the cost-based assignment of the hypothesis, that is, the percentage of the index block for nested cyclic coupling in the buffer cache. It will affect the cost of using the indexed nested cycle. Set this parameter to a higher value, which can make the nested loop link relative to the optimizer. Value range: 0 - 100%. Default: 0 job_queue_processes: Description: Only used to copy the environment. It specifies the number of SNP job queue processes for each routine (SNP0, ... SNP9, SNPA, ... SNPZ). To automatically update the table snapshot or execute the request created by DBMS_JOB, set this parameter to a value of 1 or more.
Value range: 0 to 36 Default: 0 MAX_TRANSACTION_BRANCHES: Description: Control the number of branches in distributed transaction processing. Set max_transaction_branches to a lower value, can reduce the amount of space of the shared pool based on max_transaction_branches * distributed_transactions * 72 bytes. This parameter has been discarded in version 8.1.3. Value range: 1 - 32 Default: 8 Compatible: Description: Allows you to use a new release while ensuring backward compatibility with previous versions. Value range: The default is the current release. Default: Determine Archive_Lag_target by the release: Description: This parameter is associated with time-based thread advanced features. Any integer in value range: 0 or [60, 7200]. Default: 0 is the default value, and the time-based thread advanced feature is disabled. Otherwise, the value will represent the number of seconds AQ_TM_Processes: Description: If it is greater than zero, the time monitoring of the queue message will be enabled. This time value can be used to specify the delay and failure attributes of the message (for the development of the application). Value range: 0 - 10 Default: 0 TraceFile_Identifier: SPFILE: Description: Specifies the name of the currently used server parameter file. Value range: Static Parameter default: SPFile parameter can be defined in client PFile to indicate the name of the server parameter file to use. When the server uses the default server parameter file, the value of the SPFILE is to be set by the server internally. Logmnr_max_persistent_sess: standby_file_management: TRACE_ENABLED: IFILE: Description: Used to embed other parameter files in the current parameter file. You can use this parameter multiple times on multiple lines of a parameter file, but you can only have a three-level nested. Value range: Any valid parameter file name (syntax is ifile = parameter_file_name). Default: null remote_listener: global_context_pool_size: Description: The amount of memory used to store and manage the global application environment is assigned from SGA. Value range: Any integer value. Default: 1 m PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT: FIXED_DATE: Description: The data returned by sysdate. This value is useful for testing that must always return a fixed date rather than the system date. Use dual quotation or not using quotation marks. Do not use single quotes. Value range: YYYY-MM-DD-HH24: MI: SS (or default Oracle date format). Default: NULL DB_NAME: Description: A database identifier should correspond to the name specified in the CREATE DATABASE statement. Value range: Any valid name can be up to 8 characters. Default: None (but should be specified) Cluster_Database: cluster_interConnects: CLUSTER_DATABASE_INSTANECTS: SQL_Version: Replication_Dependency_tracking: Description: Tracking Correlation Correlation The copy server is critical to spread the changes made in parallel mode. If set to false, the read / write operation on the database will run faster, but it is not possible to generate relevant information about parallel propagation for the replication server. Value Range: True | False Default: True (ie Enabling Read / Write Relevance Track) Remote_OS_Roles: Description: Set Remote_OS_Roles to True, allowing the role by the remote client's operating system. If set to False, the database is identified and managed by the database database.
Value Range: True | False Default: False Remote_OS_AUTHENT: Description: Set Remote_OS_AUTHENT to TRUE, allowing the value of OS_AUTHENT_PREFIX to verify the remote client. Value range: true | false default: false open_links: Description: Specifies the maximum number of connections to the remote database at the same time in a session. This value should be equal to or exceeds the number of databases referenced in a single SQL statement that references multiple databases, so that all databases can be opened to perform this statement. Value range: 0 - 255 (if it is 0, distributed transaction processing). Default: 4 Open_LINKS_PER_INSTANCE: Description: Specifies the maximum number of portable open connections in the XA application. XA transactions uses portable open connections to cache these connectors after submitting a transaction. If the user created a connection is a user who has transaction processing, each transaction can share the connection. Value range: 0 - UB4Maxval default: 4 Remote_login_passwordfile: Description: Specifies whether an operating system or a file checks for a password with permissions. If set to none, Oracle will ignore the password file. If you are set to Exclusive, you will verify each password file with a database. If set to Shared, multiple databases share the SYS and INTERNAL password file users. Value range: None | Shared | Exclusive Default: None HS_AUTOREGOSTER: None HS_AUTOREGOSTER: Description: Enable or disable automatic self-registration of the "Heterogeneous Service (HS) agent. If enabled, the information will be uploaded into the data dictionary to reduce overhead when establishing subsequent connections through the same agent. Value Range: True | False Default: True Global_Names: Description: Specifies whether the database link is as you connected with the connected database. If this value is false, no check is executed. To make the naming conventions in distributed processing, set this parameter to true. Value Range: True | False Default: True Distributed_Transactions: Description: A database that can be involved in distributed transaction processing. If this value is reduced due to the frequent network failure, it will cause a large number of unprecedented transactions. Value range: 0 - Transactions. Default: COMMIT_POINT_STRENGTH: Description: A value for determining the location of the submission point in the distributed transaction. Value range: 0 -255 Default: Determine DB_DOMAIN according to the operating system: Description: Specify the extension of the database name (for example: US.Oracle.com) to make the database name created in a domain, it is recommended to specify this value. Value range: any string separated by the sentence, with a maximum of 128 characters. Default: World DBLINK_ENCRYPT_LOGIN: Description: When connecting to other Oracle Server, the database link uses an encrypted password. Value Range: True | False Default: false backup_tape_io_slaves: Description: A recovery manager parameter, is used to determine whether the read or write tape is to use a server process or an additional I / O dependency. Value range: true | false default: false tape_asynch_io: Description: Used to control the I / O operation of the sequential device (for example, back up Oracle data or restore or restore Oracle data from the tape) . This value is set to true if your platform supports the asynchronous I / O operation of the sequential device; if the execution of asynchronous I / O is unstable, set this value to false.
Value Range: True | False Default: false log_file_name_convert: Description: Converts the file name of a log file on the primary database to the alternate database. After adding a log file to a primary database, you must add a corresponding file to the standby database. This parameter replaces the log_file_name_convert parameter in Oracle7. Value Range: Any format of the path / file name '' and '' spare log files of the path / file name '' and '' alternate log files: NULL FAL_SERVER: Description: Specify this alternate database FAL server. This value is an Oracle Net service name. This Oracle NET service name is assumed to be properly configured on an alternate database system, which can point to the expected FAL server. Value range: A string value of the Oracle Net service name. FAL_Client: Description: Specify the FAL service (configured via the FAL_Server parameter) to reference the FAL client's FAL client name. The value of this parameter is an Oracle Net service name. This Oracle NET service name is assumed to be properly configured on the FAL server system, which can point to the FAL client (ie: this alternate database). Value range: A string value of the Oracle Net service name. DRS_START: Description: Make Oracle to determine if the DRMON process should be started. DRMON is an Oracle background process that does not cause fatal errors. As long as the routine exists, the process exists. Value range: True | false. Default: false remote_archive_enable: Description: Controls whether to perform redo log file archive operations to remote targets. This parameter value must be set to "True" so that the Oracle database routine remote archives over the redo log file and / or receives the redo log file for remote archiving. Value range: false | True Default: True Standby_preserves_Names: Description: Indicates whether the file name on the standby database is the same as the file name on the main database. Value range: True or False. Note: If the value is set to true, and the standby database is on the same system on the same system, the primary database file may be overwritten. Default: false. StandBy_archive_dest: Description: Specifies the arrival position of the archive log from a primary routine. Standby_archive_dest and log_archive_format are used to virtual fully qualified archived log file names on the standby location. The RFS server on the standby database will use this value instead of archive_log_dest. Value range: Null string or a valid path / device name of a non-RAW type. Default: NULL DB_FILE_NAME_CONVERT: Description: Convert file names on a new data file on the primary database to the file name on the standby database. Value range: A valid master / alternate directory and file name pair. Default: No max_enable_roles: Description: Specify the maximum number of database roles (including sub-roles) that a user can enable. The actual number of characters that users enable to be 2 plus max_enabled_roles, because each user has two additional roles: public and user's own roles. Value range: 0 -148 Default: 20 O7_DICTIONARY_ACCESSIBILITY: Description: Mainly used to port from Oracle7 to Oracle8i. If this value is true, system permissions (such as select any table) will not limit access to each object in the SYS scheme (Oracle7 behavior).
If this value is false, only users who have been granted Select_Catalog_Role, Execute_catalog_role or delete_catalog_role permissions can access objects in the SYS scheme. Value Range: True | False Default: True SQL92_Security: True SQL92_Security: Description: Specifies whether a value to perform a update or delete reference list column needs to have a SELECT permission to have a table level. Value range: True | False Default: false audit_trail: Description: Enable or disable database audit. If the parameter is TRUE or DB, the audit record will be written in the Sys.Aud $ table; if the parameter is OS, a operating system file is written. Value range: None | false | DB | TRUE | OS default: None rdbms_server_dn: Description: The only judgment of the RDBMS server. It is used to retrieve corporate roles in a corporate directory service. For more information, see "Oracle Advanced Security Administrator's Guide". Value range: All X.500 unique discriminating name format values. Default: No OS_Roles: Description: Determine if the operating system or database is identified for each user. If set to TRUE, the role of all database users will be fully managed by the operating system. Otherwise, the role will be identified and managed by the database. Value Range: True | False Default: false os_authent_prefix: Description: Use the user's operating system account name and password to verify users connected to the server. The value of this parameter is connected to the operating system account of each user. To remove the OS account prefix, specify a null value. Value range: any identifier. Default: Depending on the operating system (usually 'ops $') Object_cache_max_size_percent: Description: Specifies the cache growth of the session object over the percentage of the best cache size, the maximum size is equal to the best size plus this percentage and the best Size product. If the cache size exceeds this maximum size, the system will try to narrow the cache to the optimal size. Value range: 0% to the maximum value according to the operating system. Default: 10% Object_cache_optimal_size: Description: Specifies that if the cache exceeds the maximum size, the session object cache will be reduced to the size. Value range: 10K to the maximum value according to the operating system. Default: 100K session_max_open_files: Description: Specifies the maximum number of bfiles that can be opened in any given session. Once this number is reached, you will not be able to open more files in this session. This parameter also depends on the operating system parameter MAX_OPEN_FILES. Value range: 1 - at least (50, Max_Open_Files on OS). Default: 10 Parallel_execution_message_size: Description: Specify the size of the parallel execution (parallel query, PDML, parallel recovery, and replication) messages. If the value is greater than 2048 or 4096, a larger shared pool is required. If parallel_automatic_tuning = true, the message buffer will be specified outside of the large storage pool. Value range: 2148 - infinity. Default: If parallel_automatic_tuning is false, usually 2148; if parallel_automatic_tuning is true, the value is 4096 (depending on the operating system). Paralle_min_percent: Description: Specifies the minimum percentage of threads on parallel execution requirements. Set this parameter, you can ensure that the parallel execution is displayed when there is no proper query slave process, and the query will therefore do not execute.
Value range: 0 -100 Default: 0, indicating that this parameter is not used. Parallel_Automatic_TUNING: Description: If set to true, Oracle will determine the default value to control the parameters performed in parallel. In addition to setting this parameter, you must also set parallelism for tables in the system. Value range: true | false default: false parallel_threads_per_cpu: Description: Description A CPU can handle the number of processes or threads in parallel execution, and optimize parallel adaptive algorithms and load balancing algorithms. If the computer has a sign of overload when performing a typical query, it should be reduced. Value range: any non-zero value. Default: Depending on the operating system (usually 2) Parallel_broadcast_enabled: Description: By using a hash coupled or merged join, you can connect multiple big result sets to a small result set (by byte instead of behavior) Improve performance when measuring size. If this value is set to True, the optimizer can propagate each row in the small result set into each cluster database processing line in the large set. Value range: true | false default: false parallel_adaptive_multi_user: Description: Enable or disable an adaptive algorithm to improve the performance of multi-user environments using parallel execution. This feature is implemented by starting the query by automatically reducing the request. When parallel_automatic_tuning = true, its effect is best. Value range: True | FALSE Default: If parallel_automatic_tuning = true, the value is true; otherwise, false parallel_max_servers: Description: Specifies the maximum number of parallel execution servers or parallel recovery processes for a routine. If necessary, the query of the query server assigned when the routine starts will increase to this amount. Value range: 0 -256 Default: Determine Parallel_Servers by CPU_Count, Parallel_Automatic_TUNING and Parallel_ADAUTOMATIC_TUNING and Parallel_ADAUTOMATIC_TUNING and Parallel_ADAUTOMATIC_UNING and Parallel_Adaptive_Multi_User Determine Parallel_MIN_SERVERS Description: Specifies the minimum number of query server processes created by Oracle after execution of the startup routine. Value range: 0 - Parallel_max_servers. Default: 0 log_archive_dest_state_3: Description: Specifies the availability status of the corresponding archive log target parameter (log_archive_dest_3). If enabled, the log target will be archived. If delay, this goal will be excluded from the archive operation until re-enabled. Value range: Enable | Defer default: enable log_archive_dest_state_4: Description: Specify the availability status of the corresponding archive log target parameter (log_archive_dest_4). If enabled, the log target will be archived. If delay, this goal will be excluded from the archive operation until re-enabled. Value range: enable | Defer default: enable log_archive_dest_state_5: Description: Specifies the availability status of the corresponding archive log target parameter (only log_archive_dest_5). If enabled, the log target will be archived. If delay, this goal will be excluded from the archive operation until re-enabled. Value range: Enable | Defer default: enable log_archive_dest_state_6: Description: Identify the most recent user-defined status of the specific log archive target. Value range: Enable - If the target property is valid, enable archive log target; Defer - Even if the target property is valid, delay processing archive log target; or Alternate, delay processing archive log target, until another target failure This goal is automatically enabled (provided that the properties of the alternate target must be valid).
Log_archive_dest_state_7: Description: Identify the most recent user-defined status of the specific log archive target. Value range: Enable - If the target property is valid, enable archive log target; Defer - Even if the target property is valid, delay processing archive log target; or Alternate, delay processing archive log target, until another target failure This goal is automatically enabled (provided that the properties of the alternate target must be valid). Log_archive_dest_state_8: Description: Identifies the nearest user-defined status of the specific log archive target. Value range: Enable - If the target property is valid, enable archive log target; Defer - Even if the target property is valid, delay processing archive log target; or Alternate, delay processing archive log target, until another target failure This goal is automatically enabled (provided that the properties of the alternate target must be valid). Log_archive_dest_state_9: Description: Identify the nearest user-defined status of a specific log archive target. Value range: Enable - If the target property is valid, enable archive log target; Defer - Even if the target property is valid, delay processing archive log target; or Alternate, delay processing archive log target, until another target failure This goal is automatically enabled (provided that the properties of the alternate target must be valid). Log_archive_start: Description: N applies only if the database is in the "archive log" mode. It specifies that the redo log is automatically replicated. The recommended value is true, that is, the automatic archive is performed; otherwise manual intervention is required, and the Alter System Archive Log ... command is required to block the routine hang. Value range: true | false default: false log_archive_duplex_dest: Description: Specifies another archive target outside log_archive_dest. In the Oracle8i Enterprise Edition, this parameter is replaced by log_archive_dest_n. Value range: A NULL string, or any valid path or device name, except for the original partition. Default: null log_archive_format: Description: log_archive_format is useful if the database is in the "archive log" mode. The text string is used in conjunction with the variable% s (log sequence number) and% T (thread number) to specify the unique file name of each archive reform log file. This string is attached to the log_archive_dest parameter. Value range: Any valid file name. Default: Determined log_archive_max_processes in accordance with the operating system: Description: Specifies the number of ARCH processes required. If log_archive_start = true, this value can be evaluated when routine startup; it is also possible to evaluate when the ARCH process is called via SQL * Plus or SQL syntax. Value range: 1 - 10 (including endpoint) any integer. Default: 1 log_archive_dest_2: Description: Five local (specified location) or remote (specified service) destination location in the target location, archived redo log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Value range: syntax (null_string | service = tnsnames-service | location = Directory-Spec) [mandatory | optional] [reopen = integer] default: null log_archive_min_succeed_dest: Description: Definition must copy it to the log file Minimum number of targets. This value should be greater than or equal to the number of MANDATory targets in log_archive_dest_n.
Value range: 1 - 5 (if used in common use with log_archive_duff_duplex_dest, limit at 1-2). Default: 1 log_archive_trace: Description: Controls the output generated by the archive log process. This process can initiate an ARCN background process (specified as an arcn in the output log as an arcn) to a remote file server (RFS) process (RFS) process in the output log in the output log in the output log. . Value range: 0: Disable archive log tracking (this is the default setting) 1: Reform log file Tracking Archive 2: Tracing Archive Status of Each Archive Log Target 4: Tracking Archive Operation Phase 8: Tracking Archive Log Target Activity 16: Tracking detailed archive log target activity 32: Tracking archive log target parameter modification 64: Tracking ARCN Process Status Activity Default: 0 log_archive_dest_10: Log_archive_Dest_3: Description: Five local (specified location) or remote (specified service) target location Three, archived redo log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Value range: syntax for (null_string | service = tnsnames-service | location = Directory-SPEC) [MANDATORY | OPTIONAL] [reopen = integer] Default: null log_archive_dest: Description: Five locally (specified location) or remote (specified service ) The third in the target location, archived redo log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Value range: Syntax of (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer] Default: NULL log_archive_dest_state_2: Description: Specifies the corresponding archive log destination parameters (only the LOG_ARCHIVE_DEST_2) of Availability status. If enabled, the log target will be archived. If delay, this goal will be excluded from the archive operation until re-enabled. Value range: Enable | Defer default: enable log_archive_dest_5: Description: Five local (specified location) or remote (specified service) target location in the target location can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Value range: Syntax of (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: Description: Specifies the corresponding archive The availability status of log target parameters (only log_archive_dest_1). If enabled, the log target will be archived. If delay, this goal will be excluded from the archive operation until re-enabled. Value range: Enable | Defer default: enable log_archive_dest_state_10 Description: Specifies the target of the archive log.
Value range: Local file system location (disk location) or remote archive location specified by Oracle Net Service Name (TNS Service). : Log_archive_dest_4: Description: Five local (specified location) or remote (specified service) target location in the target location, archived redo log files can be replicated at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Value range: Syntax of (null_string | SERVICE = tnsnames-service | LOCATION = directory-spec) [MANDATORY | OPTIONAL] [REOPEN = integer] Default: NULL create_bitmap_area_size: Description: CREATE_BITMAP_AREA_SIZE specified amount of memory to create a bitmap index allocated . Value range: Depending on the operating system. Default: 8 MB PGA_AGGREGATE_TARGET: Description: Specifies the total memory of all server processes connected to the routine. Please set this parameter to a positive number before enabling the Auto Setup Workspace. This part of the memory does not reside in SGA. The database uses this parameter value as the amount of target PGA it uses. When this parameter is set, you want to subtract SGA from the total amount of system memory available for Oracle routines. The remaining memory can then be assigned to the PGA_AGGREGATE_TARGET. Value range: Integer adds alphabet K, M or G to specify this limit as kilobytes, megabytes or gigabytes. The minimum is 10m, the maximum value is 4000G default: "Not specified", indicating that the automatic optimization of the work area is completely disabled. Sort_Area_Size: Description: sort_area_size In byte, specify the maximum amount of memory used to sort. After the sort is complete, the rows will return and the memory will be released. Increasing this value can increase the efficiency of large sorting. If the amount is exceeded, a temporary disk segment will be used. Value range: The value equivalent to the value of 6 database blocks (minimum) to the value (maximum) determined by the operating system. Default: Depending on the operating system, sort_area_retained_size description: In-byte, specified the maximum amount of the user's global zone (UGA) memory that is reserved after running. The last line is extracted from the sort space, the memory will be released back to the UGA instead of being released to the operating system. Value range: From the value of the value equivalent to the two database blocks to the value of sort_area_size. Default: Sort_area_size's value bitmap_merge_area_size: Description: Specifies the amount of memory to be used by the merge from a scan for a scan for an index. Value range: Depending on the system. Default: 1MB WORKAREA_SIZE_POLICY: Description: Specifies the policy of adjusting the workspace size. This parameter controls the mode where the work area is optimized. Value range: auto, manual. Default: If the PGA_AGGREGATE_TARGET is set, it is auto; otherwise it is Manual. Hash_Area_size: Description: Configured with parallel execution operations and DML or DDL statements. It specifies the maximum amount of memory you want to use to have a hash link in bytes. For more information, see Manual Oracle8i Concepts. Value range: 0 to the value determined according to the operating system. Default: Derife: 2 * sort_Area_SIZE Parameter DB_CREATE_ONLINE_LOG_DEST_4: Description: Set the default location created online log and control file. If you do not specify a file name when you create an online log or control file, use the default file name. Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files. DB_CREATE_ONLINE_LOG_DEST_3: Description: Set the default location of the online log and control file.
If you do not specify a file name when you create an online log or control file, use the default file name. Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files. DB_FILES: Description: The maximum number of data files that can be opened for the database. Value range: MaxDataFiles - Depending on the operating system. Default: Depending on the operating system (200 on the Solaris system) DB_create_online_log_dest_2: Description: Set the default location of the created online log and control file. If you do not specify a file name when you create an online log or control file, use the default file name. Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files. DB_CREATE_ONLINE_LOG_DEST_1: Description: Set the default location of the created online log and control file. If you do not specify a file name when you create an online log or control file, use the default file name. Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files. DB_CREATE_FILE_DEST: Description: Set the created data file, control file, and the default location of the online log. Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files. Control_files: Description: Specify one or more control file names. Oracle recommends using multiple files for different devices or OS files. Value range: 1 - 8 file name (with path name). Default: Depending on the operating system, DB_CREATE_ONLINE_LOG_DEST_5: Description: Set the default location of the created online log and control file. If you do not specify a file name when you create an online log or control file, use the default file name. Value range: File system directory name. This directory must already exist. This directory must have permission to allow Oracle to create files. Large_pool_size: Description: Specify the size of the distribution stack of the large pool, which can be shared servers as session memory, used as a parallel execution message buffer and a disk I / O buffer for RMAN backup and recovery. Value range: 600K (minimum);> = 20000m (maximum value is based on the operating system). Default: 0, unless parallel execution or dbwr_io_slaves shared_pool_size: Description: In-byte, specify the size of the shared pool. Shared pools contain objects such as shared cursors, stored processes, control structures, and parallel execution message buffers. Larger values can improve the performance of multi-user systems. Value range: 300 kB - Depending on the operating system. Default: If it is a 64-bit operating system, the value is 64MB; in other cases, the value is 16MB. Java_pool_size: Description: In-byte, specify the size of the Java storage pool, which is used to store Java methods and classes defined in shared memory, and ported to Java session spaces at the end of the call. For more information, see Oracle8i Java Developer's Guide. Value range: Depending on the operating system. Default: Depending on the operating system, Shared_Pool_ReServed_size: Description: Specifies the space to be reserved for a larger continuous shared pool memory request to avoid decline in performance caused by debris. The size of the pool should comply with such conditions: all large processes and packages that can be stored to prevent objects from shared pool refresh and universally required. Value range: Shared_pool_reserved_min_alloc to half (bytes) of Shared_Pool_Size. Default: Shared_pool_size value 5% CURSOR_SHARING: Description: Control You can terminate the SQL statement type of shared the same shared cursor. Value range: Force: Mandatory expression is different, but statements have the same statement to share a cursor.
Exact: Share a cursor only exactly the same SQL statement. Default: Exact Open_CURSORS: Description: Specify a maximum number of cursors (environmental area) that can be opened at a session, and restrict the size of the PL / SQL cursor cache used by PL / SQL to avoid the user again to re-perform the grammar analysis. Please set this value high so that the application can prevent the application to exhaust the open cursor. Value range: 1 - Operating system limit value. Default: 64 Serial_reuse: Description: Specifies what type of SQL cursor should utilize serial reusable memory functions. If cursor_space_for_time = true, the serial_reuse value will be ignored when it is handled as a condition set to disable or null. Value range: disable | SELECT | DML | PLSQL | All | Null Default: null session_cached_cursors: Description: Specifies the number of session cursors to cache. After multiple syntax analysis of the same SQL statement, its session cursor will be moved to the cursor cache of the session. This can shorten the time of grammatical analysis, because the cursor is cached by a cache without reopening. Value range: 0 to the value determined according to the operating system. Default: 0 CURSOR_SPACE_FOR_TIME: Description: When a cursor is cited to share the SQL zone, determine whether the SQL area remains in the shared pool or pressing the expiration process. Value range: True | False Default: false (Over Period) ROLLBACK_SEGMENTS: Description: Specifies one or more back sections to get during the routine startup process, even if the number exceeds the value of Transactions / Transactions_Per_Rollback_SEGMENT. The formula is Rollback_SEGMENTS = (RBSEG_NAME [, RBSEG_NAME] ...) value range: Any return to the DBA_ROLLBACK_SEGS except SYSTEM. Default: NULL (By default, use public return) UNDO_SUPPRESS_ERRORS: Description: Allows users to ignore errors when the RBU operations (such as ALTER ROLLBACK Segment Online) are tested in SMU mode. This allows users to use SMU functions before converting all applications and scripts to SMU mode. Value range: true or false default: false. MAX_ROLLBACK_SEGMENTS: Description: Specifies the maximum size of the back section of the cache in the SGA. This value specifies the maximum number of returns to the return segments that can be held in the same way simultaneously (i.e., the state inuse). Value range: 2 -65535 Default: Maximum (30, Transactions / Transactions) undo_retendion: Description: The undo_retrion parameter is used to specify the total amount of submitted revoke information to be retained in the database. This parameter value can be set when the routine starts. The undo space required to meet the revocation reservation requirement: undospace = rd * UPS, where undoSpace is represented by the number of undo blocks, and the RD is represented by the undo_retention in seconds, and the UPS is represented by the number of blocks per second. Value range: The maximum allowed is (2 ** 32) seconds. Default: 30 seconds. Transactions_per_rollback_segment: Description: Specifies the number of parallel transactions allowed for each retraction section. The minimum number of returned segments obtained at startup is Transactions divided by this parameter value. If you are named after the parameter rollback_segments, you can get these checkback segments. Value range: 1 - Depending on the operating system.
Default: 5 undo_management: Description: Specifies which revoke space management mode should be used. If set to Auto, the routine will start in SMU mode. Otherwise it will be started in RBU mode. In RBU mode, the undo space is allocated as externally like a refund. Under SMU mode, the revoked space will be allocated externally like withdrawal tables. Value Range: Auto or Manual Default: If the undo_management parameter is ignored if the first routine is started, the default value Manual will be used, and the routines will be started in the RBU mode. If this is not the first routine, you will start the routine when the undo mode is used in other existing routines. Undo_tablespace: Description: The withdrawal table space is only used to store undo information. Undo_tableSpace only allows you to use in System Management Undegers (SMU) mode. The routine will use the specified undo tablespace,
Default: 0 db_block_checksum: Description: DBWN, ARCH, and SQL * LOADER Whether to read or write a checksum for each data block or write computing block. Value range: True | False Default: false shadow_core_dump: Description: A parameter for UNIX uses to specify whether to dump SGA information into a generated core file. If set to FULL, SGA will be included in the core dump. If set to Partial, SGA will not be documented. Value range: Full | Partial default: Full DB_BLOCK_CHECKING: Description: The block used to control whether to check the transaction management is damaged. Value range: true | false default: false background_core_dump: Description: Do SGA information into a generated core file (for UNIX). Value Range: Full | Partial Default: Full Event: Description: Used by Oracle Technical Support Personnel to debug the system. In general, the value should not be changed. Value range: Not available. Default: None User_Dump_Dest: Description: Specifies the path name to write the display of the debug track file in one user process. For example, this directory can be set this: the C: / Oracle / UTRC; the UNIX operating system on the NT operating system; or the disk $ UR3: [Oracle.utrc] on the VMS operating system: [Oracle.utrc]. Value range: A valid local path name, directory, or disk. Default: Determined TIMED_STATISTICS: Description: Time information for the operating system is collected, which can be used to optimize the database and SQL statements. To prevent overhead due to the time of the operating system request time, set this value to zero. Set this value to TRUE is also useful for viewing the progress of the long operation. Value range: True | FALSE Default: false Timed_OS_Statistics: Description: Used by the system administrator to collect operating system statistics. To effectively use resources, set this value only when needed. For a dedicated server, the operating system statistics will be collected in the case where the user connection, disconnection, and pop-up calls (if the specified time limits) is being harvested. Statistics will be collected for calls or pop-up for calling or pop-up. Value range: Time in seconds. Default: 0 (operating system statistics are not refreshed) Core_Dump_dest: Description: Specifies the directory name (for UNIX) of the core dump location. Value range: Any valid directory name. Default: Oracle_Home / DBS Oracle_Trace_collection_name: Description: Specify the Oracle Trace Collection Name and use it in the output file name (collect definition file .cdf and data collection file .dat). If the parameter is not empty, and Oracle_Trace_enable = true, you will start a default Oracle Trace collection until the value is set to NULL again. Value range: A valid collection name, which can be 16 characters (except for platforms using 8 characters file names). Default: null oracle_trace_collection_path: Description: Specify the Oracle Trace Collection Definition File (.cdf) and Data Collection File (.dat) The directory path name is located. Value range: Complete directory path name. Default: Depending on the operating system (usually Oracle_Home / Otrace / Admin / CDF) Background_dump_dest: Description: Specifies the path name (directory or) path name (LGWR, DBW n, etc.) written in the Oracle operation Disk). It also defines the location of the database warning file that records important events and messages.
Value range: Any valid directory name. Default: Oracle_Home / Rdbms / log (Depending on the operating system) Oracle_Trace_enable: Description: To enable Oracle TRACE collection for the server, set this value to True. If set to True, the server can use Oracle Trace. To start a collection process, specify a non-null value for Oracle_Trace_collection_name; or use Oracle TRACE Manager to start a collection. Value range: true | false default: false oracle_trace_collection_size: Description: Specify the maximum size of the Oracle Trace collection file in bytes. Once the size of the collection file reaches this maximum, the collection will be disabled. If the value range is specified as zero, there is no size limit. Value range: 0 -4294967295 Default: 5242880 Oracle_Trace_facility_path: Description: Specifies the directory path name where the Oracle Trace tool is defined (.fdf). Value range: Complete directory path name. Default: Oracle_Home / Otrace / Admin / FDF / (depending on the operating system) SQL_TRACE: Description: Disable or enable SQL tracking devices. If set to True, the optimized information will be collected, which is useful for improvement. Since the use SQL tracking device will trigger the system overhead, TRUE should only be used in the case of optimization information. Value range: true | false default: false oracle_trace_facility_name: Description: Specify the Oracle Trace Product Definition File Name (.fdf file name). This file contains definition information for all events and data items that can be collected using Oracle TRACE data collection API. Oracle recommends using the default file orcled.fdf. Value range: A valid device name, longest 16 characters. Default: Oracled Max_Dump_file_size: Description: Specifies the maximum size of each tracking file. If you are worried that the trace file will occupy too much space, you can change this limit. If the dump file can meet the maximum size allowed by the operating system, specify this value as "unlimited". Value range: 0 - Unlimited (can be used with 'k' or 'm') default value: 1000 blocks resource_limit: Description: Determine if resource restrictions are implemented in the database summary file. If set to FALSE, resource restrictions are disabled. If the value is True, the resource limit is enabled. Value range: True | FALSE Default: false resource_manager_plan: Description: If this value is specified, the Explorer will activate all child (child planning, instruction, and user group) of the plan and routine. If not specified, the Explorer will be disabled, but you can use the alter system command. Value range: Any valid string. Default: Null sessions: Description: Specify the total amount of user sessions and system sessions. The default is greater than Processes to allow recursive sessions. Value range: Any integer value. Default: Derife (1.1 * processes 5) java_soft_sessionspace_limit: Description: Specify the 'soft restriction' of Java memory used in the Java session in bytes. If the user's session duration Java status uses too much memory, Oracle will generate a warning and write a message to the trace file. Value range: 0 - 4GB default: 0 CPU_Count: Description: Oracle's number of CPUs (used to calculate other parameter values). Do not change this value.
Value range: 0 - no limit. Default: Auto Set Java_Max_SESSIONSPACE_SIZE: Description: In-byte, specifies the maximum amount of memory used in the server running in the server. It is used to store Java status of each database. If the user's session duration Java state exceeds this value, the session will be terminated due to insufficient memory. Value range: Depending on the operating system. Default: 0 Processes: Description: Specifies the maximum number of operating system user processes that can be connected to an Oracle Server. This value should allow all backend processes, such as a job queue (SNP) process and parallel execution (PNNN) process. Value range: 6 to a value set according to the operating system. Default: Determine the control_file_record_keep_time: Description: Description: Description: The recording in the control file must be reserved for the shortest time (days). Value range: 0 -365 Default: 7 log_checkpoint_timeout: Description: Specifies the maximum time interval (second number of seconds) that appears from the next checkpoint. The time value is specified as 0 and will disable the time-based checkpoint. Lower values can shorten the time of routine recovery, but may cause excess of disk operation. Value range: 0 - no limit. Default: Oracle8i: 900 seconds. Enterprise version: 1800 second recovery_parallelism: Description: Specifies the number of processes that participate in routines or media recovery. If the value is 0 or 1, it indicates that the recovery will be executed in a serial manner by a process. Value range: Depending on the operating system (cannot exceed Parallel_Max_serve). Default: Determine FAST_START_MTTR_TARGET according to the operating system: Description: Specifies the time required to recover from a single database routine (estimated second). FAST_START_MTTR_TARGET will be converted to a set of parameters internally to modify the operation of the database, thereby controlling its recovery time within a certain range in the total "recovery average time (MTTR)". This parameter is only supported by versions with the "Quick Start Fault Recovery" function. Value range: [0, 3600]. It calculates the number of data buffer cache entries and is greater than the limit of the number of blocks in the maximum log. Default: 0 log_checkpoints_to_alert: Description: Specifies that the checkpoint information is recorded in the warning file. This parameter is useful for determining whether the checkpoint is in the desired frequency. Value Range: True | False Default: false fast_start_io_target: Description: Specifies the number of I / O required during system crash or routine recovery. This value is more accurate than DB_BLOCK_MAX_DIRTY_TARGET controls the recovery process. Value range: 0 (disable I / O recovery limit) or 1000, to all buffers in the cache. Default: All buffers in the cache log_checkpoint_interval: Description: Specifies the number of OS blocks (rather than database blocks) in the redo log file before the checkpoint is displayed. No matter how this value is, checkpoints will appear when switching the log. Lower values can shorten the time required for routine recovery, but may result in excess of disk operation. Value range: None limit (this parameter can be disabled). Default: Depending on the operating system, log_buffer: Description: In-byte, specifies that the amount of memory used to cache these entries before the LGWR will write to the redo log file. Reduction entries Reserve a record of changes made to the database block. If the value is greater than 65536, the redo log file I / O can be reduced, especially on systems with long-time transaction or a large transaction. Value range: Depending on the operating system.
Default: The maximum value is 500K or 128K * CPU_Count, the two are more read_only_open_delayed: Description: Use to speed some operations, such as: Start a large database and most of which are stored in read-only table Space. If you are set to True, you will first access the data files in the read-only table space when reading data from the tablespace. For side effects that may be generated, see Server Reference Manual. Value Range: True | False Default: false parallel_instance_group Description: A cluster database parameter, identifier is used to generate a parallel routine group that generates a parallel execution from parallel. Parallel operations only generate parallel execution of parallel to the routines that specify a matching group in its instance_groups parameters. Value range: A string representing the group name. Default: Group Parallel_server consisting of all current active routines: Description: Set Parallel_server to TRUE to enable the cluster database option. Value range: true | false default: false parallel_server_instances: Description: The number of currently configured routines. It is used to determine the size of the SGA structure, which is determined by the number of routines configured. Correctly setting this parameter will improve SGA's memory usage. There are several parameters to be calculated using this quantity. Value range: any non-zero value. Default: 1 thread: Description: A cluster database parameter, used to specify a unique redo line number for each routine. This routine cannot be activated in the case where the routine redo thread is disabled. If this value is zero, it means there is an enabled public thread to be available. Value range: 0 - The maximum number of threads enabled. Default: 0 GC_FILES_TO_LOCKS: Description: A cluster database parameter that is used to map parallel cache management (PCM) lock to data files. Syntax: gc_files_to_locks = 'file_list = lock_count [! Block] [r] [EACH] [: ...]' default: null instance_number: Description: A cluster database parameter, used to specify a unique number to map routines To a database object created using the FreeEList Groups stored parameters. Use this value in the instance clause of the ALTER TABLE .... The allocate extent statement can dynamically allocate the routine. Value range: 1 to max_instances (specified when creating a database). Default: Minimum available number (depending on the order of routine startup and instance_number value specified for other routines) Active_instance_count: Description: Allows a routine as a main routine in clusters composed of two routines, Another routine is a second routine. If the routines included in the cluster are more than two, this parameter has no effect. Value range: 1 or> = number of routines in the cluster. Default: None Lock_Name_Space: Description: Specifies the Distributed Lock Manager (DLM) to generate a namespace of the lock name. If there is an alternate database or cloned database in the same cluster, it is best to set this value. Value range: There are up to 8 characters and special characters are not allowed. Default: null max_commit_propagation_delay: Description: A cluster database parameter, used to specify the system change number (SCN) included in the SGA of one routine, allow the longest time (in 1/100 seconds) ). This is a performance parameter that requires a change, because the SCN may not be refreshed based on time.
