Name
|
Description
|
Default Values
|
BITMAP_merge_area_size
|
Relevant
only for systems containing bitmap indexes. It specifies the
amount of memory Oracle uses to merge bitmaps retrieved
from a range scan of the index. A larger value usually improves
performance, because the bitmap segments must be sorted before
being merged into a single bitmap.
|
Range: OS dependent
Oracle: 1048576 (1 MB)
EDM:16777216 (16 MB)
(For
SS mode only)
|
COMPATIBLE
|
Allows
you to use a new release, while at the same time guaranteeing
backward compatibility with an earlier release. This parameter
also allows you to take advantage of the maintenance improvements
of a new release immediately in your production systems without
testing the new functionality in your environment.
This
is helpful when you need to revert to an earlier release.
|
Range: Default release to current one
Oracle: 10.2.0
EDM: 10.1.0
|
CREATE_bitmap_area_size
|
Relevant
only for systems containing bitmap indexes. It specifies the
size of memory allocated for bitmap creation.
|
Range: OS dependent
Oracle: 8388608 (8 MB)
EDM: 16777216 (16 MB)
(For
SS mode only)
|
CURSOR_sharing
|
Determines what kind of SQL statements can share
the same cursors.
EXACT causes only identical SQL statements
to share a cursor.
FORCE forces statements that might
differ in some literals, but are otherwise identical to share
a cursor unless the literals affect the meaning of the statement.
SIMILAR allows to share a cursor
by statements which might differ in some literals, but are otherwise
identical.
|
Range: FORCE | EXACT |
SIMILAR
Oracle: EXACT
EDM: FORCE
|
CURSOR_space_for_time
|
Allows you to use more space for cursors in
order to save time. It affects both the shared SQL
area and the clients private SQL area.
TRUE: Shared SQL areas are kept pinned
in the shared pool.
FALSE: Shared SQL can be de-allocated
from the library cache to make room for new SQL statements.
|
Range: TRUE | FALSE
Oracle: FALSE
EDM: TRUE
|
DB_cache_size
|
Specifies the size of the DEFAULT
buffer pool for buffers with the primary block size (the block
size defined by the DB_Block_SIZE parameter).
The value must be at least the size of one granule
(smaller values are automatically rounded up to the granule
size).
A value of zero is the size of DEFAULT
pool for the SYSTEM tablespace.
|
Oracle 48 MB, rounded up to the nearest
granule size.
EDM: OLTP (40% of Total Memory for
Oracle).
DSS (35% of Total Memory for Oracle)
Hybrid (45% of Total Memory for Oracle)
where,
Total Memory for Oracle is 70 percent of Physical
RAM
|
DB_files
|
Specifies the maximum number of database files
that can be opened for this database. If you increase the value
of DB_files , you must shut down and restart
all instances accessing the database before the new value can
take effect.
|
Range: Min: Actual no. of datafiles
in database.
Max: Value specified in the MAXDATAFILES
clause the last time CREATE DATABASE or CREATE CONTROLFILE
was executed.
Oracle: 200
EDM: Me (100). Department (255),
Company (500), Enterprise (1000)
|
DB_file_multiblock_ read_count
|
This is one of the parameters you can use to
minimize I/O during table scans. It specifies the maximum number
of blocks read in one I/O operation during a sequential scan.
|
Range: OS dependent
Oracle: 8
EDM: OLTP (16), DSS(64)
Hybrid (32)
|
DISPATCHERS
|
Configures dispatcher processes in the Shared
Server architecture. The parsing software supports a name value
syntax to enable the specification of attributes in a position-independent
case-insensitive manner. If you want the dispatcher to listen
on specific port/listener for the Shared Server, you can specify
PORT and LISTENER attributes in addition
to PROTOCOL, DISPATCHERS and CONNECTIONS.
|
Oracle None
EDM: (PROTOCOL=TCP) (DISPATCHERS=1)
(CONNECTIONS=1024)
(For SS mode only)
|
HASH_area_size
|
Relevant to parallel execution operations and
to the query portion of DML or DDL statements.
It specifies the maximum amount of memory, in bytes, to be used
for hash joins.
|
Range: 0 to OS dependent
Oracle: 2 * value of SORT_area_size
EDM: 2 * value of SORT_area_size
(For Shared Server (SS) mode only)
|
HASH_join_enabled
|
Specifies whether the optimizer should consider
using a hash join as a join method. When set to FALSE,
hashing is not available as a join method.
When set to TRUE, the optimizer compares
the cost of a hash join with other types of joins, and selects
hashing if it gives the best cost.
|
Range: TRUE, FALSE
Oracle: TRUE
EDM:
TRUE for DSS / Hybrid
FALSE for OLTP
|
JAVA_pool_size
|
Specifies the size in bytes of the Java pool,
from which the Java memory manager allocates most Java state
during runtime execution.
|
Range:
Min - the granule size
Max - OS dependent
Oracle: 24 MB, rounded up to the
nearest granule size
EDM: 1 M
|
JOB_queue_processes
|
Specifies the maximum number of processes, which
can be created for the execution of user jobs. If you have Text
Indexes, you need this parameter to be set for scheduling text
index sync and optimize.
|
Range: 0 to 1000
Oracle: 0
EDM: 10
|
LARGE_pool_size
|
Allows you to specify the size in bytes of the
large pool allocation heap. The large pool allocation heap is
used in shared server systems for session memory, by parallel
execution for message buffers, and by backup processes for disk
I/O buffers.
|
Range: 300 KB to at least 2 GB (actual
maximum is OS specific)
Oracle: 0 if:
Pool is not required by parallel execution
DBWR_io_slaves is not set
Otherwise, derived from values of:
EDM: 20 M, If Shared Server
(SS) mode is enabled.
(For SS mode only)
|
LOCAL_listener
|
Specifies a network name that resolves to an
address or address list of Oracle Net local listeners (that
is, listeners that are running on the same machine as this instance).
The address or address list is specified in the TNSNAMES.ORA
file or other address repository as configured for your
system.
CES uses this parameter when Shared Server (SS)
is enabled in order to make the dispatchers listen to the listener
port. This parameter will be useful when non-default listener
port number (Other than 1521) is used with Sharer Server mode.
|
Oracle (ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521))
EDM: (ADDRESS = (PROTOCOL=TCP)(HOST=<hostname>)(PORT=<Value
of TNS Listener Port specified in EDM Database Setup>))
(For SS mode only)
|
LOG_buffer
|
Specifies the size of memory, in bytes, that
Oracle uses when buffering redo entries to a redo log file.
|
Range: Operating system dependent
Oracle: Operating system specific.
Maximum: 500K or 128K * CPU_COUNT, whichever is greater.
EDM: 512K or 128k * CPU COUNT, whichever
is lesser.
|
LOG_checkpoint_interval
|
Specifies the frequency of checkpoints in terms
of the number of redo log file blocks that can exist between
an incremental checkpoint and the last block written to the
redo log.
|
Range: Unlimited
Oracle: Oracle 0
EDM: 101% of the Redo Log file size
|
LOG_checkpoint_timeout
|
Specifies that the incremental checkpoint is
at the position where the last write to the redo log (sometimes
called the "tail of the log") was integer seconds ago. This
parameter also signifies that no buffer will remain dirty (in
the cache) for more than integer seconds. The value is specified
in seconds.
|
Oracle 1800 secs
EDM:: 0
|
MAX_dispatchers
|
Specifies the maximum number of dispatcher processes
allowed to be running simultaneously. The default value applies
only if dispatchers have been configured for the system.
|
Range: 5 or number of dispatchers
configured, whichever is greater.
Oracle: 5
EDM: 4
(For SS mode only)
|
MAX_dump_file_size
|
Specifies the maximum size of trace files (excluding
the alert file).
|
Range: 0 to Unlimited, or UNLIMITED
Oracle: UNLIMITED
EDM: 10240
|
MAX_shared_servers
|
Specifies the
maximum number of shared server processes allowed to be running
simultaneously. If artificial deadlocks occur too frequently
on your system, you should increase the MAX_shared_ servers
|
Range: OS dependent
Oracle: Derived from
SHARED_SERVERS (either 20 or 2*SHARED_SERVERS)
EDM:
6 (For Me Concurrent Users model)
8 (For Department Concurrent Users model)
12 (For Company Concurrent Users model)
18 (For Enterprise Concurrent Users model)
(For SS mode only)
|
NLS_date_format
|
Specifies the
default data format to use within TO_CHAR and
TO_DATE functions. |
Range: Any valid format mask not
exceeding a fixed length.
Oracle: Derived from NLS_territory
EDM: YYYY-MM-DDHH24.MI.SS
|
NLS_language
|
Specifies the default language of the database.
This language is used for messages, day and month names, symbols
for AD, BC, AM, and PM,
and the default sorting mechanism.
|
Range: Any valid language name
Oracle: OS dependent, derived from
NLS_LANG environment variable.
EDM: Specified in the NLS_LANG
field while setting up the environment variables for the database.
|
NLS_terrritory
|
Specifies the name of the territory whose conventions
are to be followed for day and week numbering. This parameter
also establishes the default date format, the default decimal
character and group separator, and the default ISO and local
currency symbols.
|
Range: Any valid territory name
Oracle: OS dependent
EDM: Specified in the
NLS_LANG field while setting up
the environment variables for the database.
|
OPEN_cursors
|
Specifies the number of open cursors (handles
to private SQL areas) a session can have at once. You can use
this parameter to prevent a session from opening an excessive
number of cursors.
|
Range: 1 to 4294967295 (4 GB -1)
Oracle: 50
EDM: 1024
|
OPTIMIZER_features _enable
|
Allows you to change the behavior of the
Oracle optimizer based on a release number. For example, if
you migrate your database from 8.0.5 to 8.1.5, but you want
to keep the 8.0.5 optimizer behavior, you can do so by setting
this parameter to 8.0.5.
|
Range: 8.0.0, 8.0.3 - 8.0.7, 8.1.0,
8.1.3 to 8.1.7, 9.0.0, 9.0.1, 9.2.0, 10.1.0, 10.2.0
Oracle: 10.2.0
EDM: 10.1.0
|
OPTIMIZER_index_caching
|
Allows you to adjust the behavior of cost-based
optimization to favor nested loops joins and IN-list iterators.
|
Range: 0 to 100
Oracle: 0
EDM: OLTP (99), DSS (15),
Hybrid (40)
|
OPTIMIZER_index_cost_ adj
|
Allows you to tune optimizer behavior for access
path selection to be more or less index friendly that is, to
make the optimizer more or less prone to selecting an index
access path over a full table scan.
|
Range: 1 to 10000
Oracle: 100
EDM: 10 OLTP (10), DSS (100), Hybrid
(45)
|
OPTIMIZER_max_ permutations
|
Restricts the number of permutations of the
tables the optimizer will consider in queries with joins. Such
a restriction ensures that the parse time for the query stays
within acceptable limits.
|
Range: 4 to 80000
Oracle: If OPTIMIZER_FEATURES_ENABLE
is set to 9.0.0 or higher, then 2000.
OPTIMIZER_FEATURES_ENABLE is set to 8.1.7 or
lower, then 80000.
EDM: 999
|
OPTIMIZER_mode
|
OPTIMIZER_mode specifies the goal
of optimization of SQL statements.
RULE specifies that rule-based optimization
is to be used unless hints are specified in the query.
CHOOSE specifies cost-based optimization
for a SQL statement if the data dictionary contains statistics
for at least one table accessed in the statement. If no such
statistics are present, the optimizer uses the rule-based approach.
FIRST_ROWS causes the optimizer to
use cost-based optimization to choose execution plans that minimize
response time.
ALL_ROWS causes the optimizer to
use cost-based optimization to choose execution plans that minimize
total execution time.
|
Range: FIRST_ROWS_ [1 | 10|100| 1000]
| FIRST_ROWS | ALL_ROWS| CHOOSE RULE
Oracle: CHOOSE
EDM: CHOOSE
|
PGA_aggregate_target
|
Specifies the target aggregate PGA memory available
to all server processes attached to the instance. You must set
this parameter to enable the automatic sizing of SQL working
areas used by memory- intensive SQL operators such as sort,
group by, hash-join, bitmap merge, and bitmap create.
|
Range:
Min: 10 MB
Max: 4096 GB - 1
Oracle: 0 (automatic memory management
is turned OFF by default)
EDM:
OLTP (20% of Total Memory for Oracle)
DSS (50% of Total Memory for Oracle)
Hybrid (25% of Total Memory for Oracle)
where,
Total Memory for Oracle is 70 percent of Physical
RAM
|
PRE_page_sga
|
Determines whether all SGA pages are brought
into memory at instance startup.
|
Range: TRUE, FALSE
Oracle: FALSE
EDM:: TRUE
|
PROCESSES
|
Specifies the maximum number of operating system
user processes that can simultaneously connect to Oracle.
|
Range: 6 to OS dependent
Oracle: Derived from PARALLEL_max_servers
EDM:
If Dedicated Server is selected, then 7 + #Concurrent
Users + JOB_queue_processes+20
If Parallel Query Optimizer is selected, then 7 + #Concurrent Users
+ PARALLEL_max_servers + JOB_queue_processes+20
If Shared Server (SS) is selected then 7+MAX_shared_servers+MAX_dispatchers+JOB_
queue_ processes+20
If PQO and Shared Server (SS) are selected,
then 7+PARALLEL_max_servers+MAX_shared_servers+ MAX_ dispatchers+JOB_queue_processes+20
|
QUERY_rewrite_enabled
|
Allows you to enable or disable query rewriting
globally for the database.
|
Range: TRUE, FALSE
Oracle: FALSE
EDM: TRUE
|
SESSIONS
|
SESSIONS specifies the maximum number
of sessions that can be created in the system. Because every
login requires a session, this parameter effectively determines
the maximum number of concurrent users in the system.
You should always set this parameter explicitly
to a value equivalent to your estimate of the maximum number
of concurrent users, plus the number of background processes,
plus approximately 10% for recursive sessions.
|
Range: 1 to 231
Oracle: Derived: (1.1 * PROCESSES) + 5
EDM: Value of "Concurrent Users"
in EDM: DB Setup screen + BACKGROUND SESSIONS (7)
+ Anticipated DEDICATED CONNECTIONS (20) + CUSHION (20)
(For SS mode only)
|
SESSION_cached_cursors
|
Allows you to specify the number of session
cursors to be cached. Repeated parse calls of the same SQL statement
causes the session cursor for that statement to be moved into
the session cursor cache. Subsequent parse calls will find the
cursor in the cache and need not reopen the cursor. Oracle uses
a least recently used (LRU) algorithm to remove entries in the
session cursor cache to make room for new entries when needed.
|
Range: 0 to OS dependent
Oracle: 0
EDM: 50
|
SGA_max_size
|
Specifies the maximum size of SGA for the lifetime
of the instance.
|
Oracle Initial size of SGA at startup,
dependent on the sizes of different pools in the SGA such as
buffer cache, shared pool, large pool and so on.
EDM: (80% of PHYSICAL RAM - Total
Memory of Oracle) + (Buffer Cache + Log Buffer + Java Pool +
Shared Pool)
where,
Total Memory of Oracle is 70% of PHYSICAL RAM
Buffer cache is OLTP (40% of Total Memory for Oracle)
DSS (35% of Total Memory for Oracle)
Hybrid (45% of Total Memory for Oracle)
Log Buffer is MIN (512K, 128K*CPU COUNT), Java
Pool is 1 MB, and Shared pool is OLTP (35% of Total Memory for
Oracle)
DSS (10% of Total Memory for Oracle)
Hybrid (25% of Total Memory for Oracle)
|
SHARED_pool_size
|
Specifies the size of the shared pool in bytes.
The shared pool contains shared cursors, stored procedures,
control structures and other structures.
|
Range:
Min - the granule size
Max - OS dependent
Oracle:
32 - bit platforms: 8MB, rounded up to the nearest
granule size
64 - bit platforms: 64 MB, rounded up to the
nearest granule size
EDM:
OLTP (35% of total memory for Oracle)
DSS (10% of Total Memory for Oracle)
Hybrid (25% of total memory for Oracle)
where,
total memory for Oracle is 70% of Physical RAM
|
SHARED_servers
|
Specifies the number of server processes that
you want to create when an instance is started up. If system
load decreases, this minimum number of servers is maintained.
Therefore, you should take care not to set SHARED_servers
to a very high value at system startup.
|
Range: OS dependent
Oracle: If Shared Server architecture
is enabled, 1 else 0
EDM:
2 (For Me Concurrent Users and Department Concurrent
Users model)
4 (For Company Concurrent Users and Enterprise
Concurrent Users model)
(For SS mode only)
|
SHARED_server_sessions
|
Specifies the total number of shared server
architecture user sessions to allow. Setting this parameter
enables you to reserve user sessions for dedicated servers.
|
Range: 0 to SESSIONS - 5
Oracle: Derived: the lesser of CIRCUITS
and SESSIONS - 5
EDM: Value of "Concurrent Users"
in EDM: DB Setup screen + CUSHION (20)
(For SS mode only)
|
SORT_area_size
|
Specifies in bytes the maximum amount of memory
Oracle will use for a sort.
|
Range:
EDM: 8388608
(For SS mode only)
|
STAR_transformation _enabled
|
Determines whether a cost-based query transformation
will be applied to star queries.
|
Range: TRUE | FALSE | TEMP_DISABLE
Oracle: FALSE
EDM: TEMP_DISABLE
|
STATISTIS_level
|
Sets the statistics collection level of the
database.
|
Range: ALL | TYPICAL | BASIC
Oracle: TYPICAL
EDM: TYPICAL
|
UNDO_management
|
Specifies which undo space management mode the
system should use. When set to AUTO, the instance starts in
automatic undo management mode. In manual undo management mode,
undo space is allocated externally as rollback segments.
|
Range: MANUAL | AUTO
Oracle: MANUAL
EDM: AUTO
|
UNDO_retention
|
Specifies (in seconds) the amount of committed
undo information to retain in the database. You can use
UNDO_ RETENTION to satisfy queries that require
old undo information to rollback changes to produce older images
of data blocks. You can set the value at instance startup.
|
Range: 0 to maximum value represented
by 32 bits
Oracle: 900
EDM: 900
|
UNDO_tablespace
|
Specifies the undo tablespace to be used when
an instance starts up. if this parameter is specified when the
instance is in manual undo management mode, an error occurs
and startup fails.
|
Range: Legal name of an
existing undo tablespace
Oracle: The first available undo
tablespace in the database
EDM: UNDO_TS1
|
Parallel Query Option
|
PARALLEL_min_servers
|
Specifies the minimum number of parallel execution
processes for the instance. This value is the number of parallel
execution processes Oracle creates when the instance is started.
|
Range: 0 to value of PARALLEL_max_servers
Oracle: 0
EDM:: 2
|
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.
|
Range: 0 to 3599
Oracle: Derived from the values of CPU_COUNT,
PARALLEL_automatic_tuning, and PARALLEL_adaptive_multi_user
EDM: 8
|
PARALLEL_min_percent
|
Operates in conjunction with PARALLEL_max_servers
and PARALLEL_min_ servers . It allows you to specify
the minimum percentage of parallel execution processes (of the
value of PARALLEL_ max_servers ) required for parallel
execution.
|
Range: 0 to 100
Oracle: 0
EDM: 0
|
PARALLEL_threads_per _cpu
|
Specifies the default degree of parallelism
for the instance and determines the parallel adaptive and load
balancing algorithms. The parameter describes the number of
parallel execution processes or threads that a CPU can handle
during parallel execution.
|
Range: Any non-zero number
Oracle: OS dependent, usually 2
EDM: 4
|
PARALLEL_adaptive_multi_ user
|
When set to TRUE, enables an adaptive
algorithm designed to improve performance in multiuser environments
that use parallel execution.
|
Range: TRUE | FALSE
Oracle: Derived from the value of
PARALLEL_automatic_tuning
EDM:TRUE
|
PARALLEL_automatic_ tuning
|
When set to TRUE, Oracle determines
the default values for parameters that control parallel execution.
|
Range: TRUE | FALSE
Oracle: FALSE
EDM: FALSE
|