PROCESSES
Property
Description
Parameter type
Integer
Default value
100
Modifiable
No
Range of values
6 to operating system dependent
Basic
Yes
Oracle RAC
Multiple instances can have different values.
PROCESSESspecifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.
The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.
UNDO_RETENTION
Property
Description
Parameter type
Integer
Default value
900
Modifiable
ALTER SYSTEM
Range of values
0 to 231 - 1
Oracle RAC
Oracle recommends that multiple instances have the same value.
UNDO_RETENTIONspecifies (in seconds) the low threshold value of undo retention. For AUTOEXTEND undo tablespaces, the system retains undo for at least the time specified in this parameter, and automatically tunes the undo retention period to satisfy the undo requirements of the queries. For fixed- size undo tablespaces, the system automatically tunes for the maximum possible undo retention period, based on undo tablespace size and usage history, and ignoresUNDO_RETENTIONunless retention guarantee is enabled.
The setting of this parameter should account for any flashback requirements of the system. Automatic tuning of undo retention is not supported for LOBs. The RETENTION value for LOB columns is set to the value of the UNDO_RETENTION parameter.
The UNDO_RETENTION parameter can only be honored if the current undo tablespace has enough space. If an active transaction requires undo space and the undo tablespace does not have available space, then the system starts reusing unexpired undo space. This action can potentially cause some queries to fail with a "snapshot too old" message.
The amount of time for which undo is retained for the Oracle Database for the current undo tablespace can be obtained by querying the TUNED_UNDORETENTION column of the V$UNDOSTAT dynamic performance view.
JOB_QUEUE_PROCESSES
Property
Description
Parameter type
Integer
Default value
1000
Modifiable
ALTER SYSTEM
Range of values
0 to 1000
Basic
No
Oracle RAC
Multiple instances can have different values.
JOB_QUEUE_PROCESSESspecifies the maximum number of job slaves per instance that can be created for the execution ofDBMS_JOBjobs and Oracle Scheduler (DBMS_SCHEDULER) jobs.DBMS_JOBand Oracle Scheduler share the same job coordinator and job slaves, and they are both controlled by theJOB_QUEUE_PROCESSESparameter.
If the value of JOB_QUEUE_PROCESSES is set to 0, then DBMS_JOB jobs and Oracle Scheduler jobs will not run on the instance.
If JOB_QUEUE_PROCESSES is set to a value in the range of 1 to 1000, then DBMS_JOB jobs and Oracle Scheduler jobs will run. The actual number of job slaves created for Oracle Scheduler jobs is auto-tuned by the Scheduler depending on several factors, including available resources, Resource Manager settings, and currently running jobs. However, the combined total number of job slaves running DBMS_JOB jobs and Oracle Scheduler jobs on an instance can never exceed the value of JOB_QUEUE_PROCESSES for that instance.
Advanced replication uses Oracle Scheduler for data refreshes. Oracle Streams Advanced Queuing uses Oracle Scheduler for message propagation. Materialized views use Oracle Scheduler for automatic refreshes. Setting JOB_QUEUE_PROCESS to 0 will disable these features as well as any other features that use Oracle Scheduler or DBMS_JOB.
UTL_FILE_DIR
Property
Description
Parameter type
String
Syntax
UTL_FILE_DIR =pathname
Default value
There is no default value.
Modifiable
No
Range of values
Any valid directory path
UTL_FILE_DIRlets you specify one or more directories that Oracle should use for PL/SQL file I/O. If you are specifying multiple directories, you must repeat theUTL_FILE_DIRparameter for each directory on separate lines of the initialization parameter file.
All users can read or write to all files specified by this parameter. Therefore all PL/SQL users must be trusted with the information in the directories specified by this parameter.
Note:
If you list multiple values, all entries of this parameter must be on contiguous lines of the parameter file. If you separate them with other parameters, Oracle will read only the last (contiguous) lines.