Oracle9i Initialization Parameters Chinese Description 13

xiaoxiao2021-03-06  72

User_dump_dest:

Description: Specifies the path name to write the directory of the debug track file in one user process. For example, this directory can set this: C: / on the NT operating system

Oracle / utrc; / Oracle / UTRC; or VMS operating system on the UNIX operating system

Disk $ ur3: [Oracle.utrc].

Value range: A valid local path name, directory, or disk.

Default: Depending on the operating system

TIMED_STATISTICS:

Description: Collect the timing information of the operating system, which can be used to optimize the database and SQL statements. To prevent overhead due to request time from operating system,

Please 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: Use the system administrator to collect operating system statistics. To effectively use resources, set this value only when needed. For dedicated servers,

The operating system statistics are collected in the case where the user is connected, disconnected, and the pop-up call (if the specified time limit) is exceeded. For shared servers,

Statistics will be collected for the call to the push 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 position.

Value range: Any valid directory name.

Default: Oracle_Home / DBS

Oracle_trace_collection_name:

Description: Specify Oracle Trace Collection and use 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, it will start a default

Oracle TRACE collected until this 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: Specifies the directory path name where the Oracle Trace Collection Definition File (.cdf) and Data Collection File (.dat) are 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 of writing tracking files for background processes (LGWR, DBW N, etc.) during Oracle operation

(Catalog or 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:

Note: To enable Oracle Trace Collection for the server, set this value to true. If set to TRUE, the server can use

Oracle trace. To launch a collection process, please be oracle_trace_collection_name

Specify a non-null value; or use Oracle Trace Manager to launch a collection.

Value range: True | False

Default: False

Oracle_trace_collection_size:

Description: Specifies the maximum size of the Oracle Trace collection file in bytes. Once the size of the collection file reaches this maximum,

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 definition file (.fdf) of the Oracle Trace tool is specified.

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 Oracle TRACE

Data Collects all events and data items for the product collected by the 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 reach the maximum size allowed by the operating system,

Please specify this value as "Unlimited".

Value range: 0 - Unlimited (can be used in 'k' or 'm')

Default: 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:

Note: If this value is specified, the Explorer will activate all child (subprints, instructions, and user groups) of the plan and routine. If not specified, the resource manager will be disabled.

But use

The alter system command can also be enabled.

Value range: Any valid string.

Default: null

转载请注明原文地址:https://www.9cbs.com/read-119655.html

New Post(0)