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