Session_max_open_files:
Note: Specifies the maximum number of BFiles that can be opened in any given session. Once this is reached,
This will then be unable 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: Specifies the size of the message (parallel query, PDML, parallel recovery, and replication) messages. If the value is greater than 2048 or 4096,
There is a need for a larger sharing pool. If parallel_automatic_tuning = true,
The message buffer will be specified outside 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:
Note: Specifies the minimum percentage of threads that perform the requirements for parallel. Set this parameter, you can ensure that the parallel execution will display an error message when there is no proper query dependency 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:
Note: 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: Describes the number of processes or threads that a CPU can process during 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:
Note: By using a hash coupled or merged join, you can measure the size of multiple large-result sets to a small result set (by byte instead of behavior))
Improve performance. 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 that use parallel execution methods. Automatically reduce the parallelism of the request by system load,
This function is implemented when the query is started. 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 one routine. If necessary, the query of the query server assigned when the routine starts will increase to this amount.
Value range: 0 -256
Default: determined by cpu_count, parallel_automatic_tuning and parallel_adaptive_multi_user
Parallel_min_servers
Note: The minimum number of query server processes created by Oracle is specified as parallel execution boot routines.
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: Specifies 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 (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 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_7:
Description: Identify 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_8:
Description: Identify 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).
