Partition_view_enabled:
Description: If you set partition_view_enabled to true, the optimizer will be 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 analyzing a query with a large number of coupling,
The optimization program will consider the number of exchanges of the table. This helps ensure that the time of syntax analysis of the query is within an acceptable limit.
But the price is unable to 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:
Note: Optimize the performance of the optimizer can be used to optimize the performance of the Optimizer in consideration of too many or too little index access paths. The lower the value, the easier the optimizer is easier to select an index. That is to say,
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 if cost-based query conversion will be applied to a star query. If set to True, the optimizer will consider the cost-based conversion to the star query;
If set to false, no conversion will be used; if set to TEMP_DISABLE, you will consider query conversion, but do not use a temporary table.
Value range: True | False | TEMP_DISABLE
Default: False
Optimizer_Mode:
Description: Specify the behavior of the optimization program. If set to rule, a rule-based optimization program will be used unless the query contains a prompt. If set to Choose,
The cost-based optimization program will be used, unless the table in the statement does not contain statistics. All_rows or first_rows
Always use cost-based optimization procedures.
Value Range: Rule | Choose | First_ROWS | All_Rows
Default: choose
Optimizer_index_caching:
Description: Adjust the false setting based on cost-based optimization procedures,
That is, in the buffer cache, it is desirable for the percentage of index blocks for nested cyclic coupling. It will affect the cost of using the indexed nested cycle. Set this parameter to a higher value,
The nesting loop linkage can be less costly relative to the optimization program.
Value range: 0 - 100%.
Default: 0
Job_Queue_Processes:
Description: It is 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,
Max_Transaction_Branches * Distributed_Transactions * 72 bytes,
Reduce the amount of space for shared pools. 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: Determined by the release
Archive_lag_target:
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:
Note: 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: 0TraceFile_Identifier:
SPFILE:
Description: Specifies the name of the server parameter file currently used.
Value range: static parameters
Default: The spfile parameter can be defined in the 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_ssions:
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:
Note: 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. For tests that must always return fixed date rather than system date,
This value is useful. 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