AQ_TM_PROCESSES

Property Description
Parameter type Integer
Default value 0
Modifiable ALTER SYSTEM
Range of values 0 to 10
Basic No

AQ_TM_PROCESSES enables time monitoring of queue messages. The times can be
used in messages that specify delay and expiration properties. Values from 1 to 10
specify the number of queue monitor processes created to monitor the messages. If
AQ_TM_PROCESSES is not specified or is set to 0, then the queue monitor is not
created.

GLOBAL_NAMES

Property Description
Parameter type Boolean
Default value false
Modifiable ALTER SESSION, ALTER SYSTEM
Range of values true | false
Basic No

GLOBAL_NAMES specifies whether a database link is required to have the same name
as the database to which it connects.
If the value of GLOBAL_NAMES is false, then no check is performed. If you use or
plan to use distributed processing, then Oracle recommends that you set this
parameter to true to ensure the use of consistent naming conventions for databases
and links in a networked environment.

OPEN_LINKS

Property Description
Parameter type Integer
Default value 4
Modifiable No
Range of values 0 to 255

OPEN_LINKS specifies the maximum number of concurrent open connections to
remote databases in one session. These connections include database links, as well as
external procedures and cartridges, each of which uses a separate process.
Oracle counts one open link for the following:
■ For each user that references a public or private database link
■ For each external procedure or cartridge connection when it is executed for the
first time

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_DIR lets 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 the UTL_
FILE_DIR parameter for each directory on separate lines of the initialization
parameter file

NLS_DATE_FORMAT

Property Description
Parameter type String
Syntax NLS_DATE_FORMAT = "format"
Default value Derived from NLS_TERRITORY
Modifiable ALTER SESSION
Range of values Any valid date format mask but not exceeding a fixed length
Basic No

NLS_DATE_FORMAT specifies the default date format to use with the TO_CHAR and
TO_DATE functions. The default value of this parameter is determined by NLS_
TERRITORY

PARALLEL_MAX_SERVERS

Property Description
Parameter type Integer
Default value Derived from the values of CPU_COUNT, PARALLEL_THREADS_PER_
CPU, and PGA_AGGREGATE_TARGET
Modifiable ALTER SYSTEM
Range of values 0 to 3599
Real Application
Clusters
Multiple instances must have the same value.

PARALLEL_MAX_SERVERS specifies the maximum number of parallel execution
processes and parallel recovery processes for an instance. As demand increases, Oracle
increases the number of processes from the number created at instance startup up to
this value.