Snames-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 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.
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,
Archive reform 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
CREATE_BITMAP_AREA_SIZE:
Description: create_bitmap_Area_size Specifies the amount of memory assigned to create a bitmap index.
Value range: Depending on the operating system.
Default: 8 MB
PGA_AGGREGATE_TARGET:
Description: Specifies the target PGA total memory for 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 is not resident
SGA. The database uses this parameter value as the amount of target PGA it uses. When this parameter is set, you want to use the SGA from Oracle
The total amount of the routine is subtracted. 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 is 4000g
Default: "Not specified", indicating that automatic optimization of the workspace is completely disabled.
Sort_area_size:
Explanation: sort_area_size specifies the maximum amount of memory used in the order in bytes. After the sort is complete, each line 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, specifies the maximum amount of the user's global zone (UGA) memory that is reserved after a sorting run. The last line is extracted from the sort space,
This memory will be released back to 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 value
Bitmap_mege_area_size:
Description: Specifies the amount of memory to be used by the merger to retrieve the amount of bitmap obtained from a range of a range of the index.
Value range: Depending on the system.
Default: 1MB
Workarea_size_policy:
Description: Specifies the policy of adjusting the size of the workspace. 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: Related to 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: Derive: 2 * sort_size parameter value
DB_CREATE_ONLINE_LOG_DEST_4:
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_3:
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_FILES:
Note: 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 is 200 in 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.