The Oracle database system configures its own startup according to the parameters set in initialization parameter file init.ra, each instance first reads the different parameters set in these parameter files before starting. Parameters in the Oracle system, depending on the system usage, simply divide two categories, normal parameters, which is some parameters for the Oracle system, and other classes are special parameters, including three, outdated parameters, emphasis parameters and hidden parameters. . With the new version of the Oracle database, some parameters will be added or deleted each time.
How to query the parameters of the current version of the database system and those parameters that the current system version adds or discarded with previous versions? This article will detail how to query the various parameters in the current system version.
First, outdated parameters and emphasis parameters
In the Oracle database, the system provides several views to view system parameters. View V $ Obsolete_Parameter contains all OBSoletes and underscored parameters. Here first explains what is Oracle's outdated and emphasizes the parameters, an outdated parameter, and as the names are existed in Oracle's previous versions, but the parameters that have been eliminated in the new version are no longer used; Parameters refer to those who have kept down in the new version, but unless the parameters do not want users to use. In view V $ Obsolete_Parameter, the name of these parameters and a flag word Isspecified, which is used to indicate if this parameter is actually set in the init.ora file.
The following SQL scripts list all the expirated parameter names in the current system and whether they are set in the current system.
SQL> COL Name Format A50;
SQL> SELECT NAME, ISSPECified from V $ OBSOLETE_PARAMETER;
Talk above, the Oracle system does not discard all the parameters in the V $ Obsolete_Parameter view, but to convert some of them to emphasize the parameters, the following to discuss how to view these parameters is being discarded or converted. This can be viewed through system view X $ KSPPO, which contains a field named KSppoflag, which is used to indicate that the parameter is discarded in the current version or emphasized. If the value is 1, then the parameter has been Discard, this value is 2, indicating that the parameter is now emphasizing parameters.
SELECT KSPPONM,
Decode (Ksppoflg, 1, 'Obsolete', 2, 'underscored')
From x $ ksppo
ORDER BY KSPPONM;
Note: This view only can be seen under SYS users.
Second, hidden parameters
There is also a type of parameters in the Oracle system called hidden parameters, which is used in the system, but Oracle official does not publish parameters, which may be the parameters used in the system development. These parameters have not been introduced in all Oracle official documents, and their naming has a common feature that is all characters of '_' as parameters, such as _trace_files_public and _lock_sga_reas, etc. in Oracle 8i.
The following query can get all hidden parameters in the current system (login as SYS):
SELECT KSPPINM, KSPPSTVL, KSPPDESC
From x $ ksppi x, x $ ksppcv y
Where x.indx = y.indX
AND translate (ksppinm, '_', '#') Like '#%';
Third, the system current parameters
The following scripts list all the parameters currently used in English alphabetical order. In the listed parameters, if the parameter name has a # this symbol, the parameter is not clearly specified, and the default parameters in the system are adopted. Generally, after a new Oracle version is installed, you can first run the script, you can generate the standard init.ora file for this version database. Set PageSize 9000
SET HEAD OFF
Set term off
SELECT
Decode (Isdefault, 'True', '#') ||
Decode (IsDefault, 'True', RPAD (Name, 43), RPAD (Name, 45)) ||
'=' || Value
From v $ parameter
ORDER by name;
Parameter category Description Value range default value
ALWAYS_ANTI_JOIN Optimizer A reverse connection returns a row that conforms to the NOT IN sub-query. The optimization program verification may be reversed, if possible, proceed according to the value of this parameter. NESTED_LOOPS | MERGE | HASH NESTED_LOOPS
ALWAYS_SEMI_JOIN Optimizer A semi-connection returns a row that conforms to the exists query. If an index has not been defined on the column of the restriction subquery, the semi-connection can improve query performance. NESTED_LOOPS | MERGE | HASH NESTED_LOOPS
AQ_TM_PROCESSES 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). 0 - 10 0
AUDIT_FILE_DEST will generate an audit file in this directory for each of the SYSDBA or INTERNAL connections to the database (available only for UNIX). Any effective directory name Oracle_Home / Rdbms / Audit
AUDIT_TRAIL Security and Audit 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. None | False | DB | TRUE | OS NONE
Background_core_dump Diagnostic Statistics Do SGA information into a generated core file (for UNIX). Full | Partial Full
Background_dump_dest diagnostic statistics Specifies the path name (directory or disk) (directory or disk) written to the tracking file during the Oracle operation. It also defines the location of the database warning file that records important events and messages. Any valid directory name. Oracle_Home / Rdbms / LOG (depending on the operating system)
Backup_tape_io_slaves Backup and Restore A Recovery Manager parameter, used to determine if the read or write tape is to use a server process or an additional I / O dependency. True | False False
The Bitmap_Merge_Area_SIZE Optimizer specifies the amount of memory you want to use from a bitmap obtained from a range of scan for an index. Depending on the system. 1M
Blank_trimming ANSI compatibility value is True, even if the source length is longer than the target length (SQL92 compatible), it also allows allocation data. RUE | FALSE FALSE
The buffer_pool_keep cache is in size (assigned from DB_BLOCK_BUFFERS). The purpose is to keep the object in memory to reduce I / O. Specific string value. Such as: buffers: 400
The buffer_pool_recycle cache is in size (assigned from DB_BLOCK_BUFFERS). The purpose is to remove it after using the object to reuse the memory. Specific string values such as: buffers: 50 No commission / copied snapshot A value for determining the location of the submission point in the distributed transaction. 0 -255 According to the operating system
Compatible transplantation and compatibility allow for use of a new release while ensuring backward compatibility with previous versions. The default is the current release. Determined by the release
Control_file_record_keep_time Redo the minimum time (days) that the recording that the recovery and control file control file must be retained (days). 0 -365 7
Control_files redo the sunshine, the recovery and control file specify one or more control file names. Oracle recommends using multiple files for different devices or OS file images. 1 - 8 file name (with path name). Depending on the operating system
Core_dump_dest Diagnostics Directory Name (for UNIX) with statistics specifying the core dump location. Any valid directory name. Oracle_Home / DBS
The number of CPU_count processes and session Oracle (used to calculate other parameter values). Do not change this value. 0 - Unlimited is set by Oracle
The CREATE_BITMAP_AREA_SIZE Optimizer is specified as the amount of memory allocated to create a bitmap index. Depending on the operating system. 8M
The Cursor_Sharing cursor and the library cache control can terminate the SQL statement type of the share of the same shared cursor. Force: Mandatory expression is different, but the statement means the same statement sharing a cursor. Exact: Share a cursor only exactly the same SQL statement. Exact
CURSOR_SPACE_FOR_TIME Cursor and Library Cache When a cursor is clicked to share the SQL area, determine whether the SQL area remains in the shared pool or pressing the expiration process. True | False False (expired)
The number of Oracle blocks in the DB_BLOCK_BUFFERS cache and the I / O buffer cache. This parameter significantly affects the total SGA size of the routine. 4 - Depending on the operating system. 32768
DB_BLOCK_CHECKING Diagnostics is not damaged by the block for controlling whether to check the transaction management. True | False False
DB_BLOCK_CHECKSUM Cache and I / O DBWN, ARCH, and SQL * Loader are read or write to each data block or write the checksum of the check block. True | False False
DB_BLOCK_LRU_LATCHES Cache and I / O Specifies the upper limit of the number of LRU latch sets. This value is required only if the failure rate in V $ Latch exceeds 3%. 1 - CPU quantity CPU_COUNT / 2
The DB_BLOCK_MAX_DIRTY_TARGET cache can be the number of ash buffers in the I / O buffer cache. Can be used to estimate the number of blocks read during the recovery process. 1000 to the buffer cache large 0 does not limit the buffer). All buffers in the buffer cache
The DB_BLOCK_SIZE Cache and the size of the I / O Oracle database block (in bytes). This value is set when creating a database and cannot be changed thereafter. 1024 - 65536 (Depending on the operating system). 2048 (depending on the operating system)
DB_DOMAIN Distributed, replication and snapshot specifying the extension of the database name (for example, US :.Oracle.com) is unique to make the database name created in a domain, it is recommended to specify this value. Any string separated by a sentence, with a maximum of 128 characters. World
DB_FILE_DIRECT_IO_COUNT Cache and I / O Use of the number of blocks that read and write I / O operations in backup, restore, or directly. Depending on the operating system. 64
DB_FILE_MULTIBLOCK_READ_COUNT Cache and I / O The maximum number of blocks read during a single I / O operation involving a fully continuous scan. Depending on the operating system. The 8db_file_name_convert The spare database converts the file name of a new data file on the primary database to the file name on the standby database. A valid master / alternate directory and file name pair. no
DB_FILES Cache and I / O The maximum amount of data files open for this database. Depending on the operating system. According to the operating system
DB_NAME Relief Sunshine, Recovery and Control File A database identifier should correspond to the name specified in the CREATE DATABASE statement. Any valid name can be up to 8 characters. None (but should be specified)
The DB_Writer_Processes cache is the initial number of database write processes for the I / O routine. If you use DBWR_IO_SLAVES, you can only write a process. 1 - 10 1
DBLINK_ENCRYPT_LOGIN Distributed Copy Snapshot When connecting to other Oracle servers, the database link uses a encrypted password. True | False False
DBWR_IO_SLAVES The number of I / O borders used in the cache and I / O DBW0 process. DBW0 processes and their dependent are always written to disk. 0 - Depending on the operating system. 0
DISK_ASYNCH_IO Cache is asynchronous with I / O control data files, control files, and log files (ie, whether the process overlaps I / O and CPU requests during table scanning). This parameter can only be changed if your platform supports disk asynchronous I / O. True | False True
Distributed_Transactions Distributed Copy Snapshot A database is a maximum number of distributed transactions that can be involved in a database. If this value is reduced due to the frequent network failure, it will cause a large number of unprecedented transactions. 0 - Transactions The parameter value. Depending on the operating system
DML_LOCKS locks the maximum number of table locks acquired by users. A DML lock is required for each table to perform DML operations. For example, if the three users modify 2 tables, the value is required to be 6. 0 or 20 to unlimited. 4 * Transactions (derived)
Enqueue_resources locks enabled parallel processes to share resources. For example, Oracle allows a process to lock a table in sharing mode to lock another table in sharing update mode. 10 - 65535 (7.3) or 10 - No limit (8.1). Delivery (this value is greater than DML_LOCKS 20 is enough)
Event Diagnostics and Statistics are used by Oracle Technical Supporters to debug the system. In general, the value should not be changed. unavailable. no
FAST_START_S_TARGET Relivery Log Recovery and Control File 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. 0 (disable I / O recovery limit) or 1000 to all buffers in the cache. All buffers in the cache
FAST_START_PARALLEL_ROLLLLBACK Transaction Processing and Rollback Segment Performs the maximum number of processes in parallel. This value is useful on the system where most transaction processing is running. False | Low | High Low (2 * CPU_COUNT)
FIXED_DATE The data returned by other 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. YYYY-MM-DD-HH24: MI: SS (or default Oracle format). NULL
GC_DEFER_TIME OPS A parallel server parameter that determines that the server will wait for the time length (1/100 seconds) to reduce the routine before writing frequent blocks to disk, and optimizes the block access. Any positive integer (0 will disable this feature). 10
GC_FILES_TO_LOCKS OPS A parallel server parameter used to control the parallel cache management (PCM) lock to the data file. GC_FILES_TO_LOCKS = '{file_list = lock_count [! Block] [r] [EACH] [: ...]' Nullgc_releasable_locks OPS A parallel server parameter is used to specify a disabled lock element that will be used for small particle size lock allocation space. Its maximum is only affected by memory restrictions. 50 or greater. DB_BLOCK_BUFFERS value
GC_ROLLBACK_LOCKS OPS A parallel server parameter that specifies the number of distributed locks for each rollback segment block that simultaneously modified. In the case where another routine needs to have a block of reading consistency, these lock enforcement routines write the retreat block to the disk. GC_ROLLBACK_LOCKS = '{rs_list = lock_count [! Blocks] [r] [EACH] [: ...]' '0-128 = 32! 8reach'
Global_Names Distributed Copy Snapshot Specifies whether the database link is the same name 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. True | False True
Hash_area_size Sort and hash connection is related to parallel execution operations and DML or DDL statements. It specifies the maximum amount of memory you want to use for a hash connection in bytes. 0 to the value determined according to the operating system. Delivery: 2 * sort_area_size parameter value
Hash_JOIN_ENABLED Sort and hash connection If set to true, the optimizer will consider a hash connection when calculating the most effective connection method. Oracle recommends that the data warehouse application should use the TRUE value. True | False True
Hash_multiblock_io_count Sort and Hash Connection Specifies the number of consecutive blocks of a hash connection read and written in a time I / O. This value is always smaller than the maximum size of the operating system I / O represented by the Oracle block number (MAX_IO_SIZE / DB_BLOCK_SIZE). Oracle uses formula R / m <= PO2 (m / c) to calculate this value for each query. Depending on the operating system. OK is determined by the query. Show 0
Hi_shared_memory_address memory 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. Any integer value. 0
HS_AUTOREGISTER Distributed Copy Snapshot 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. True | False True
IFile other parameter files are embedded 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. Any valid parameter file name (syntax is ifile = parameter_file_name). NULL
Instance_groups OPS A parallel server parameter, you can use a comma-separated list to assign the current routine to a specific group. Use the routine group when assigning query subordinates for parallel operation. A series of group names, separated by commas. NULL
Instance_name Network Registration When multiple routines use the same service name, it is used to uniquely identify a database routine. Instance_name should not be confused with the SID, which is actually a unique identifier of each routine that shares memory on a host. Any alphanumeric characters. Database SID
Instance_number OPS A parallel server parameter used to specify a unique number to map the routines to an idle list owned by the database object created using the FreeElist GroupS stored parameters. Use this value in the instance clause of the ALTER TABLE ... You can dynamically allocate the routine. 1 to Max_instances (specified when creating a database). Minimal available numbers (depending on the order of routine startup and instance_number values specified for other routines) Java_max_sessionspace_size process and sessions in bytes, specify the maximum amount of memory available to the Java program 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. Depending on the operating system. 0
The java_pool_size pool is in bytes, specifies the size of the Java storage pool, which is used to store Java methods and classes defined in shared memory, and ported to Java objects in Java session space at the end of the call. Depending on the operating system
Java_soft_sessionspace_limit processes and sessions are in bytes, specify "soft restrictions" of Java memory used in the Java session. 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. 0 - 4GB 0
The Job_Queue_Interval job queue is only used to replicate the environment. It specifies the wake-up frequency of each SNPN background process of the routine in seconds. 1 to 3600 60
The Job_Queue_Processes job queue is only used to replicate 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. 0 to 36 0
The LARGE_POOL_SIZE pool specifies the allocation heap of the largest storage pool, which can be used as a multi-thread server (MTS) as session memory, used as a mess-up buffer, and a disk I / O buffer for RMAN backup and recovery. 600K (minimum);> = 20000m (maximum value is based on the operating system). 0, unless parallel execution or dbwr_io_slaves
License_max_sessions License Specifies the maximum number of parallel user sessions that allow simultaneous permit. After this limit is reached, only users with RESTRICTED SESSION privileges can connect to the server. All other users receive a warning message indicating that the maximum capacity of the system has reached. 0 - The number of session licenses. 0
License_max_users License Specifies the maximum number of users you can create in this database. Parallel sessions licenses and user licenses should not be enabled simultaneously. License_max_iesions or license_max_users or the value of both should be zero. 0 - The number of user licensing. 0
License_SESSIONS_WARNING License Specifies a warning limit for the number of parallel user sessions. Once this limit is reached, other users can still connect, but a message will be written to the Alert file. Users with RESTRICTED SESSION permissions will receive a warning message indicating that the system is close to the maximum capacity. 0 - license_max_sessions 0
LM_LOCKS OPS A parallel server parameter specified as the number of locks configured by the lock manager. The number of locks can be represented by equation L = R (R * (n - 1)) / n, where R is the number of resources, N is the total number of nodes, and L is the total number of locks. 512 (minimum); maximum is based on the operating system. 12000LM_RESS OPS A parallel server parameter controls the number of resources that can be locked each lock manager routine. The specified value should be less than 2 * DML_LOCKS plus about 20 lock system overhead. 256 (minimum); maximum value is based on the operating system. 6000
Local_Listener Network Registers a NET8 address list for identifying database routines on the same computer, which can be used as NET8 listeners. All routines and schedule are registered on this listener to enable client connections. This parameter covers the MTS_Listener_Address and MTS_MultiPle_Listenerse parameters discarded in version 8.1. A list of valid Net8 addresses. (Address_List = (Host = localhost) (PORT = 1521)) (ADDRESS = (Protocol = IPC))))
LOCK_NAME_SPACE OPS 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. There are up to 8 characters and special characters are not allowed. NULL
Lock_sga memory is used to lock the entire SGA in physical memory. This value will be ignored on a platform that does not support this function. True | False False
Log_archive_dest archiving is only available for the database that is running in the "archive log" mode, or is restoring the database from the archived redo log. In the 8.1 Enterprise Edition, log_archive_dest_n should be used. A NULL string, or any valid path or device name, except for the original partition. NULL
Log_archive_dest_1 Archive Five Local (Specify Location) or remote (specified service) The first archived redo log file in the target location can be copied at these target locations. This parameter is only valid in the Enterprise Edition Oracle8i database or a higher version of the database. Syntax for (null_string | service = tnsnames-service | location = directory-spec) [mandatory | optional] [reopen = integer] NULL
LOG_ARCHIVE_DEST_2
LOG_ARCHIVE_DEST_3
Log_archive_dest_4
Log_archive_Dest_5
Log_archive_dest_state_1 Archive Specifies the availability status of the corresponding archive log target parameter (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. Enable | Defer enable
LOG_ARCHIVE_DEST_STATE_2
LOG_ARCHIVE_DEST_STATE_3
LOG_ARCHIVE_DEST_STATE_4
LOG_ARCHIVE_DEST_STATE_5
Log_archive_duplex_dest archive specifies another archive target outside log_archive_dest. In the Oracle8i Enterprise Edition, this parameter is replaced by log_archive_dest_n. A NULL string, or any valid path or device name, except for the original partition. NULLLOG_ARCHIVE_FORMAT Archive log_archive_format is useful only in the "archive log" mode in the database. 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. Any valid file name. Depending on the operating system
Log_archive_max_processes archive specified the number of ARCH processes. 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. 1 - 10 (including endpoint) any integer. 1
Log_archive_min_succeed_dest archive definition The minimum number of targets that must be copied to can be copied before you override the log file. This value should be greater than or equal to the number of MANDATory targets in log_archive_dest_n. 1 - 5 (if used in common use with log_archive_duff_dest, limit in 1-2). 1
Log_archive_start archives apply only in the "archive log" mode in the database. 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. True | False False
Log_archive_trace archive control archive log process generated output. 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. . 0: Disable archive log tracking (this is the default setting) 1: Reform log file Tracking Archive 2: Tracking Archive Status of Each Archive Log Target 4: Tracking Archive Operation Phase 8: Tracking Archive Log Target 16: Tracking Detailed Archive Log Target Activity 32: Tracking Archive Log Target Parameter Modification 64: Tracking ARCN Process Status Activity 0
Log_buffer Relivery logs, recovery, and control files are used in bytes, specifying the amount of memory to cache these entries before the LGWR will write redo log entries 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. Depending on the operating system. The maximum is 500K or 128K * CPU_COUNT, and the two are more
Log_checkpoint_interval Relivery Logs, Recovery, and Control Files Specify 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. No limit (this parameter can be disabled). Depending on the operating system
Log_checkpoint_timeout Relief Log, Recovery, and Control File Specifies the maximum time interval (second number of seconds) 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. 0 - No limit. Oracle8i: 900 seconds. Enterprise version: 1800 seconds
Log_checkpoints_to_alert Relivery Log, Recovery, and Control File Specify the checkpoint information to the warning file. This parameter is useful for determining whether the checkpoint is in the desired frequency. True | false falselog_file_name_convert The backup database 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. Any format is a valid path / file name NULL for the "Path / File Name" and "Access Log File"
MAX_COMMIT_PROPAGATION_DELAY OPS A parallel server parameter that allows the maximum amount of time (in 1/100 seconds) that allows the reserved time (1/100 second) that is allowed to specify the system change number (SCN) included in the SGA of one routine. This is a performance parameter that requires a change, because the SCN may not be refreshed based on time. 0 -90000 700
Max_dump_file_size diagnostics and statistics Specify 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 in "K" or "M") 1000 blocks
Max_enabled_roles Security and Audit Specifies the maximum number of database roles (including sub-roles) that users 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. 0 -148 20
Max_rollback_segments transaction processing and rollback segments Specify 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). 2 -65535 Maximum value (30, Transactions / Transactions_Per_Rollback_SEGMENT)
MTS_CIRCUITS MTS specifies the total number of virtual circuits available for entering and outbound network sessions. This parameter is one of several parameters for the total SGA requirements for a routine. Delivery: The value of the sessions parameter (if you are using a multi-thread server architecture); otherwise 0.
MTS_DISPATCHERS Others set the number and type of the scheduler to set the shared environment of the multithreader server. Several options can be specified for this parameter. This is an example of a string value: "(protocol = TCP) (Dispatchers = 3)". The valid specified value of the parameters. NULL
MTS_Listener_Address Specifies the listener configuration of the multi-threaded server. The listener requires a listening address to handle the connection requests of 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 discarded in version 8.1.3
MTS_MAX_DISPATCHERS MTS Specifies the maximum number of scheduler processes that can run simultaneously in a multi-thread server environment. Depending on the operating system. If the scheduler has been configured, the number of dispatching programs greater than 5 is set by default.
MTS_MAX_SERVERS MTS specifies the maximum number of shared server processes that can run simultaneously in a multi-thread server environment. Depending on the operating system. 20
MTS_MULTIPLE_LISTENERS MTS specifies that the address of multiple listeners is specified separately, or specifies with an Address_List string. This parameter has been discarded in version 8.1.3. True | False False
MTS_SERVERS MTS specifies the number of server processes created for multithreaded server environments after the startup routine. Depending on the operating system. 1
MTS_Service MTS A multi-thread server parameter is used to specify a unique service name that has been registered on the scheduler to establish a database connection. If you can connect to the database without the scheduler, set this value to the same name. This parameter has been discarded in version 8.1.3. Depending on the operating system. 0MTS_SESSIONS MTS Specifies the total number of user sessions that allow for multi-threaded server architectures. Setting this parameter can retain some user sessions for a dedicated server. 0 to sessions - 5 derived: less than MTS_CIRCUITS and SESSIONS - 5
NLS_CALENDAR NLS Specifies which calendar system to use Oracle as the date format. Arabic Hijrah, ENGLISH HIJRAH, GREGORIAN, JAPANESE IMPERIAL, PERSIAN, ROC OFFICIAL (Republic of China) and Thai Buddha. Gregorian
NLS_COMP NLS Avoid using a cumbersome NLS_SORT process in the SQL statement. 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. Any valid 10-byte string specified in Oracle8i National Language Support Guide. Binary
NLS_CURRENCY NLS Specifies a string used as local currency symbols for the L digital format element. The default value of this parameter is determined by NLS_TERRITORY. Any valid 10-byte string specified in Oracle8i National Language Support Guide. Get from NLS_TERRITORY
NLS_DATE_FORMAT NLS 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 ''. Any valid date format mask, but must not exceed a fixed length. Derive
NLS_DATE_LANGUAGE NLS Specifies 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. Any valid NLS_LANGUAGE value. NLS_LANGUAGE value
NLS_DUAL_CURRENCY NLS is 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. Any valid format name. Double currency symbol
NLS_ISO_CURRENCY NLS specifies a string used as an international currency symbol for the C digital format element. The default value of this parameter is determined by NLS_TERRITORY. Any valid NLS_TERRITORY value. Get from LS_TERRITORY
NLS_LANGUAGE NLS Specifies the default language of the database, which will be used for symbols of messages, date, and month names, AD, BC, AM, and PM, as well as the default sorting mechanism. Supported languages include English, French and Japanese, and more. Any valid language name. Depending on the operating system
NLS_NUMERIC_CHARACTERS NLS 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
NLS_SORT NLS Specifies the comparison order of the ORDER BY query. For binary sorting, the comparison order of the ORDER BY query is based on the value. For language sorting, a full table scan is required to set the data in a defined language. Binary or a valid language definition name. Get NLS_TERRITORY NLS from NLS_LANGUAGE to specify a naming convention for the following, including the date and week, the default date format, the default decimal point character, and component jaw, and the default ISO and local currency symbols. Supported areas include the United States, France and Japan. Any valid area name. Depending on the operating system
NLS_TIME_FORMAT NLS Specifies a string value to set the default value of the TIME data type, which contains Hour, Minute, and Second's datetime fields. Time '09: 26: 50 '(stores the value to 7 bytes). Get from LS_TERRITORY
NLS_TIME_TZ_FORMAT NLS Specifies a pair of values (UTC, TZD), setting the default value for the Time With Time Zone data type, which contains Hour, Minute, Second, Timezone_Hour, and Timezone_minute these date time fields. UTC is the world and TZD is the local time zone. Time '09: 26: 50.20 02:00 '(stored in 9 bytes). Get from NLS_TERRITORY
NLS_TimeSTAMP_FORMAT NLS is similar to NLS_Time_Format, but it is set to the default value of the TimeStamp data type, which stores the date values of Year, Month, and Day, also store HOUR, Minute, and Second. Time value. TimeStamp '1997-01-31 09: 26: 50.10' (stored in 11 bytes). Get from NLS_TERRITORY
NLS_TimeStamp_TZ_FORMAT NLS Similar to NLS_Time_tz_Format, a pair of values specify the default value of the TimestAmp data type, which is stored in the "Month and Day", 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). Get from NLS_TERRITORY
Object_cache_max_size_percent object and LOB Specifies the cache growth of the session object to exceed the percentage of the best cache size, the maximum size is equal to the best size plus the product of this percentage and the optimum size. If the cache size exceeds this maximum size, the system will try to narrow the cache to the optimum size 0% to the maximum value according to the operating system. 10%
Object_cache_optimal_size object and LOB specifies that in the case where the cache exceeds the maximum size, the session object cache will be reduced. 10K to the maximum value determined according to the operating system. 100K
Open_CURSORS Cursor and Library Cache Specifies the maximum number of cursors (environmental areas) that can be opened at a session, and limits the size of the PL / SQL cache cache used by PL / SQL to avoid syntax analysis when the user performs the statement again. Please set this value high so that the application can prevent the application to exhaust the open cursor. 1 - Operating system limit value. 64
Open_LINKS Distributed, Copy, and Snapshot 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. 0 - 255 (if it is 0, distributed transaction processing is not allowed). 4Open_LINKS_PER_INSTANCE Distributed, Replicated, and Snapshot 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 you create a connection user is a user with transaction processing, each transaction can share connection 0 - UB4MaxVal 4
The Optimizer_features_enable optimizer allows you to change the init.ora 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. 8.0.0; 8.0.3; 8.0.4; 8.1.3. 8.0.0
Optimizer_index_caching Optimizer Adjusts the hypotheses based on cost-based optimization programs, that is, the percentage of index blocks for nested loop connections in the buffer cache. It will affect the cost of using the indexed nested loop connection. Set this parameter to a higher value, which allows the nested loop connection to the optimizer. 0 - 100%. 0
The Optimizer_Index_cost_adj Optimizer can be used to optimize the performance of the optimizer when considering 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. 1 -10000 100 (Conventional cost of an index access path)
Optimizer_max_permutations Optimization The Optimizer will consider the number of exchanges of the restriction table when analyzing queries with a large number of connections. 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. 4-2 ^ 32 (~ 4.3 g). 80,000
The Optimizer_Mode optimizer specifies the behavior of the optimal program. 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. Rule | Choose | First_ROWS | All_Rows Choose
The Optimizer_PERCENT_PARALLEL Optimizer Specifies the concurrent quantity used in its cost function. Optimizer Select the best sequence program to achieve lower values (tend to use indexes). For high values, the optimizer uses the parallelism of each object to calculate the cost of the full table scan operation. 0 -100 100
Oracle_Trace_collection_name Diagnostics and Statistics Specify Oracle Trace Collect Names and use in the output file name (set definition file .cdf and data collection file DAT). If this parameter is not empty, and Oracle_Trace_enable = true, a default Oracle Trace collection is launched until the value is set to NULL again. A valid collection name, which can be 16 characters (except for platforms using 8 characters file names). NULL
Oracle_Trace_Collection_Path Diagnostics and Statistics Specify the directory path name where the Oracle Trace Collection definition file (.cdf) and the data collection file (.dat) are located. Complete catalog path name. Depending on the operating system (usually Oracle_Home / Otrace / Admin / CDF) Oracle_Trace_Collection_Size diagnostics and statistics in bytes, specify the maximum size of the Oracle Trace collection file. 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. 0 -4294967295 5242880
Oracle_Trace_enable Diagnostics and Statistics 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. True | False False
Oracle_Trace_facility_name Diagnostics and Statistics Specify 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. A effective device name, with a maximum of 16 characters. Oracled
Oracle_Trace_facility_path Diagnostics and Statistics Specify the directory path name where the Oracle Trace tool is located. Complete catalog path name. Oracle_Home / Otrace / Admin / FDF / (depending on the operating system)
OS_AUTHENT_PREFIX security and audit 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. Any identifier. Depending on the operating system (usually "OPS $")
OS_ROLES security and auditing determine if an operating system or database is identified by 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. True | False False
Parallel_adaptive_multi_user Parallel Query Enables or disables an adaptive algorithm to improve the performance of multi-user environments using parallel execution methods. This feature is implemented by starting the query by automatically reducing the request. When parallel_automatic_tuning = true, its effect is best. True | false If parallel_automatic_tuning = true, the value is true; otherwise, false
Parallel_Automatic_TUNING Parallel Query 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. True | False False
Parallel_broadcast_enabled Optimization Programs can be improved when connecting multiple large-result sets to a small result set (measured by byte rather than behavior) by using a hash connection or merge connection. If this value is set to True, the optimizer can propagate each row in the small result set to each parallel server processing line in the large set. True | False False
Parallel_execution_message_size Parallel Query Specifies the size of the message (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. 2148 - Infinity. If parallel_automatic_tuning is false, usually 2148; if parallel_automatic_tuning is true, the value is 4096 (depending on the operating system). Parallel_instance_group OPS A parallel server parameter that identifies a parallel routine group that generates a parallel execution from a parallel. Parallel operations only generate parallel execution of parallel to the routines that specify a matching group in its instance_groups parameters. A string representing the group name. Group consisting of all current active routines
Parallel_max_servers Parallel Query 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. 0 -256 OK is determined by CPU_COUNT, Parallel_Automatic_TUNING and Parallel_adaptive_multi_user
Parallel_min_percent parallel query Specifies the minimum percentage of threads that perform the parallel execution requirements. Set this parameter, you can ensure that the parallel execution is not available in proper query dependent query, and the query will therefore do not execute. 0 -100 0, indicating that this parameter is not used.
The parallel_min_servers parallel query is specified as a minimum number of query server processes created by Oracle after the startup routine in parallel. 0 - parallel_max_servers. 0
Parallel_server OPS Sets Parallel_server to TRUE and enables parallel server options. True | False False
Parallel_server_INSTANCES OPS The number of routines that is currently configured. 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. Any non-zero value. 1
Parallel_threads_per_cpu Parallel Query 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 any non-zero value. Depending on the operating system (usually 2)
Partition_View_enabled Optimizer 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. True | False False
PLSQL_V2_COMPATIBILITY PL / SQL 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. True | False False
PRE_PAGE_SGA Memory A parameter set according to the platform, if this parameter is TRUE, all SGA pages will be loaded into memory so that the routine quickly reaches the optimal performance state. 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. True | False False
Processes Process and Session Specifies the maximum number of operating system user processes on an Oracle server simultaneously. This value should allow all backend processes, such as a job queue (SNP) process and parallel execution (PNNN) process. 6 to a value set according to the operating system. Determine the query_rewrite_enabled optimizer to enable or disable the query rewrite for the physicalized view by parallel_max_servers. 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. True | False False
Query_rewrite_integrity Optimizer Oracle Server Performs the extent of rewriting. 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. Enforces, trusted, stale_tolerated enforcesd
RDBMS_SERVER_DN Security and Audit RDBMS Server Judgment Name. It is used to retrieve corporate roles in a corporate directory service. All X.500 discriminating name format values. no
READ_ONLY_OPEN_DELAYED Cache and I / O are used to accelerate certain operations, such as launching a large database and most of which are stored in read-only tablespaces. 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. True | False False
Recovery_ParalLISM Relivery Log, Recovery, and Control File Specifies the number of processes that are involved 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. Depending on the operating system, it is not exceeded Arallel_Max_servers according to the operating system.
Remote_Dependencies_mode pl / sql is used to specify a database that is depends on the remote PL / SQL storage. If set to TimeSTAMP, the process can only be performed only if the server matches the local timestamp. If you are set to signature, you can execute the process TimeStamp | Signature TimeStamp in the case of signing security.
Remote_login_passwordfile distributed, replicated, and snapshots Specify whether the operating system or a file checks the password of the user. 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. None | Shared | Exclusive None
Remote_OS_AUTHENT distributed, copy, and snapshots set the remote_os_authe to True, allowing the value of OS_AUTHENT_PREFIX to verify the remote client. True | False False
Remote_OS_Roles Distributed, Copy, and Snapshots Set Remote_OS_Roles to TRUE, allowing roles to be assigned by remote client operating systems. If set to False, the database is identified and managed by the database database. True | False False
Replication_dependency_tracking distributed, replication, and snapshot tracking correlation is critical to the change in the reproduction server in parallel. 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. True | False True (ie enabled read / write correlation tracking)
Resource_limit processes and sessions 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. RUE | FALSE FALSERESOURCE_MANAGER_PLAN Process and Session 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. Any valid string. NULL
Rollback_SEGMENTS Transaction and Rollback Segment Specifies one or more refundable 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] ...) except SYSTEM, any return segment listed in DBA_ROLLBACK_SEGS. NULL (By default, use public return)
Row_locking ANSI Compatibility Specifies whether to get a line lock when the table has been updated or is 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. Always | Default | Intent Always
Serial_reuse cursors and library caches Specify how 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. Disable | SELECT | DML | PLSQL | All | NULL NULL
Serializable ANSI Compatibility Determines whether 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. True | False False
The service_names network is registered as a NET8 listener can be used to identify routines for a service (such as a specific database in the replication environment). If the service does not have a domain, the db_domain parameter will be attached. Service_names = name1.domain, name2.domain db_name.db_domain (if defined)
Session_cached_cursors cursor and library cache 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. 0 to the value determined according to the operating system. 0
Session_max_open_files object and LOB specify 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. 1 - at least (50, MAX_OPEN_FILES on the OS). 10
The sessions process and session specifies the total amount of user sessions and system sessions. The default is greater than Processes to allow recursive sessions. Any integer value. Delivery (1.1 * processes 5)
Shadow_core_dump Diagnostics and Statistics 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. Full | Partial fullshared_memory_address memory shared_memory_address and hi_shared_memory_address Specifies the starting address of the SGA when the runtime SGA is specified. 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. Any integer value. 0
Shared_pool_reserved_size The pool specifies the space to be reserved for a larger continuous sharing 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. Shared_pool_reserved_min_alloc to half (in bytes) of Shared_Pool_Size. 5% of the shared_pool_size value
Shared_pool_size pool in bytes, specifies 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. 300 kB - Depending on the operating system. If it is a 64-bit operating system, the value is 64MB; if other cases, the value is 16MB.
Sort_area_retained_size Sorting and Hash Connections In byte, the maximum value of the user's global zone (UGA) memory that is reserved after a sorting is 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. From the value of the value of the two database blocks to the value of sort_area_size. Value of sort_area_size
Sort_area_size Sort and hash links in bytes, specify the maximum amount of memory used in sorting. 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. The value (minimum) of the six database blocks (minimum) to the value determined by the operating system (maximum). Depending on the operating system
Sort_multiblock_read_count sorting and hash connection Specifies the number of database blocks to read each time a sorting is read from a temporary period. Temporary segment is used in sorting greater than sort_area_size. The larger the value, the more data read for each merge, but it may cause more combination. 1 - The value determined according to the system. 2
SQL92_Security Security and Audit Specifies whether the value to be executed or delete the reference list column needs to have a SELECT permission to have a table level. True | False False
SQL_Trace diagnostics and statistics 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. True | False False
SQL_Version Others unused
Standby_archive_dest archive specifies the arrival location 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. NULL string or a valid path / device name for non-RAW types. NULL
The Star_Transformation_enabled Optimizer determines 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. TRUE | FALSE | TEMP_DISABLE FALSETAPE_ASYNCH_IO Backup and Restore for controlling the I / O operation of the sequential device (eg, backup or restore the Oracle data on or back up or restore Oracle data from the tape) asynchronously. 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. True | False False
TEXT_ENABLE Other parameters that enable or disable text search. True | False False
Thread OPS A parallel server parameter for each routine to specify a unique redirect line number. 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. 0 - The maximum number of threads has been enabled. 0
TIMED_OS_STATISTICS diagnostics and statistics are used by system administrators to collect operating system statistics. To effectively use resources, set this value only when needed. For a dedicated server, the OS statistics will be collected in the case where the user is connected, disconnected, and the pop-up call (if the specified time limit) is exceeded. For multi-threaded servers, the statistics will be collected for calling or pop-up. Time in seconds. 0 (OS statistics are not refreshed)
TIMED_STATISTICS diagnostics and statistics collects timing information for the operating system, 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. True | False False
Transaction_auditing transaction and rollback segments determine if the transaction layer generates a special redo record, which contains the user's 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. True | False True
Transactions transaction processing and rollback segments Specify 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. A value. Delivery (1.1 * sessions)
Transactions_per_rollback_segment transaction processing and rollback segments Specify the number of parallel transactions allowed by each rollback section. The minimum number of returned segments obtained at startup is Transactions divided by this parameter value. If you are named other refunds in the parameter rollback_segments, you can get these checkbacks. 1 - Depending on the operating system. 5
Use_indirect_data_buffers Memory Control Supports more than 4GB of physical memory 32-bit platforms for extended buffer cache mechanisms. On other platforms, this parameter will be ignored TRUE | FALSE FALSE
User_dump_dest Diagnostics and Statistics Specify path names in which a user process is written 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]. A valid local path name, directory, or disk. Depending on the operating system, UTL_FILE_DIR PL / SQL 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. Any valid directory path. no
