O7_DICTIONARY_ACCESSIBILITY |
FALSE |
|
|
|
|
Version 7 Dictionary Accessibility Support |
active_instance_count |
|
|
|
|
|
number of active instances in the cluster database |
aq_tm_processes |
1 |
|
|
|
|
number of AQ Time Managers to start |
archive_lag_target |
0 |
|
|
|
|
Maximum number of seconds of redos the standby could lose |
audit_sys_operations |
FALSE |
|
|
|
|
enable sys auditing |
audit_trail |
NONE |
|
|
|
|
enable system auditing |
background_core_dump |
partial |
|
|
|
|
Core Size for Background Processes |
background_dump_dest |
E:\oracle\admin\oracle\bdump |
|
|
|
|
Detached process dump directory |
backup_tape_io_slaves |
FALSE |
|
|
|
|
BACKUP Tape I/O slaves |
bitmap_merge_area_size |
1048576 |
|
|
|
|
maximum memory allow for BITMAP MERGE |
blank_trimming |
FALSE |
|
|
|
|
blank trimming semantics parameter |
buffer_pool_keep |
|
|
|
|
|
Number of database blocks/latches in keep buffer pool |
buffer_pool_recycle |
|
|
|
|
|
Number of database blocks/latches in recycle buffer pool |
circuits |
170 |
|
|
|
|
max number of circuits |
cluster_database |
FALSE |
|
|
|
|
if TRUE startup in cluster database mode |
cluster_database_instances |
1 |
|
|
|
|
number of instances to use for sizing cluster db SGA structures |
cluster_interconnects |
|
|
|
|
|
interconnects for RAC use |
commit_point_strength |
1 |
|
|
|
|
Bias this node has toward not preparing in a two-phase commit |
compatible |
9.2.0.0.0 |
|
|
|
|
Database will be completely compatible with this software versio |
control_file_record_keep_time |
7 |
|
|
|
|
control file record keep time in days |
control_files |
E:\oracle\oradata\oracle\CONTROL01.CTL, E:\oracle\oradata\oracle\CONTROL02.CTL, E:\oracle\oradata\oracle\CONTROL03.CTL |
|
|
|
|
control file names list |
core_dump_dest |
E:\oracle\admin\oracle\cdump |
|
|
|
|
Core dump directory |
cpu_count |
2 |
|
|
|
|
initial number of cpu's for this instance |
create_bitmap_area_size |
8388608 |
|
|
|
|
size of create bitmap buffer for bitmap index |
cursor_sharing |
EXACT |
|
|
|
|
cursor sharing mode |
cursor_space_for_time |
FALSE |
|
|
|
|
use more memory in order to get faster execution |
db_16k_cache_size |
0 |
|
|
|
|
Size of cache for 16K buffers |
db_2k_cache_size |
0 |
|
|
|
|
Size of cache for 2K buffers |
db_32k_cache_size |
0 |
|
|
|
|
Size of cache for 32K buffers |
db_4k_cache_size |
0 |
|
|
|
|
Size of cache for 4K buffers |
db_8k_cache_size |
0 |
|
|
|
|
Size of cache for 8K buffers |
db_block_buffers |
0 |
|
|
|
|
Number of database blocks cached in memory |
db_block_checking |
FALSE |
|
|
|
|
data and index block checking |
db_block_checksum |
TRUE |
|
|
|
|
store checksum in db blocks and check during reads |
db_block_size |
8192 |
|
|
|
|
Size of database block in bytes |
db_cache_advice |
ON |
|
|
|
|
Buffer cache sizing advisory |
db_cache_size |
25165824 |
|
|
|
|
Size of DEFAULT buffer pool for standard block size buffers |
db_create_file_dest |
|
|
|
|
|
default database location |
db_create_online_log_dest_1 |
|
|
|
|
|
online log/controlfile destination #1 |
db_create_online_log_dest_2 |
|
|
|
|
|
online log/controlfile destination #2 |
db_create_online_log_dest_3 |
|
|
|
|
|
online log/controlfile destination #3 |
db_create_online_log_dest_4 |
|
|
|
|
|
online log/controlfile destination #4 |
db_create_online_log_dest_5 |
|
|
|
|
|
online log/controlfile destination #5 |
db_domain |
apconsulting.zp.ua |
|
|
|
|
directory part of global database name stored with CREATE DATABA |
db_file_multiblock_read_count |
16 |
|
|
|
|
db block to be read each IO |
db_file_name_convert |
|
|
|
|
|
datafile name convert patterns and strings for standby/clone db |
db_files |
200 |
|
|
|
|
max allowable # db files |
db_keep_cache_size |
0 |
|
|
|
|
Size of KEEP buffer pool for standard block size buffers |
db_name |
oracle |
|
|
|
|
database name specified in CREATE DATABASE |
db_recycle_cache_size |
0 |
|
|
|
|
Size of RECYCLE buffer pool for standard block size buffers |
db_writer_processes |
1 |
|
|
|
|
number of background database writer processes to start |
dblink_encrypt_login |
FALSE |
|
|
|
|
enforce password for distributed login always be encrypted |
dbwr_io_slaves |
0 |
|
|
|
|
DBWR I/O slaves |
dg_broker_config_file1 |
%ORACLE_HOME%\DATABASE\DR1%ORACLE_SID%.DAT |
|
|
|
|
data guard broker configuration file #1 |
dg_broker_config_file2 |
%ORACLE_HOME%\DATABASE\DR2%ORACLE_SID%.DAT |
|
|
|
|
data guard broker configuration file #2 |
dg_broker_start |
FALSE |
|
|
|
|
start Data Guard broker framework (DMON process) |
disk_asynch_io |
TRUE |
|
|
|
|
Use asynch I/O for random access devices |
dispatchers |
(PROTOCOL=TCP) (SERVICE=oracleXDB) |
|
|
|
|
specifications of dispatchers |
distributed_lock_timeout |
60 |
|
|
|
|
number of seconds a distributed transaction waits for a lock |
dml_locks |
748 |
|
|
|
|
dml locks - one for each table modified in a transaction |
drs_start |
FALSE |
|
|
|
|
start DG Broker monitor (DMON process) |
enqueue_resources |
968 |
|
|
|
|
resources for enqueues |
event |
|
|
|
|
|
debug event control - default null string |
fal_client |
|
|
|
|
|
FAL client |
fal_server |
|
|
|
|
|
FAL server list |
fast_start_io_target |
0 |
|
|
|
|
Upper bound on recovery reads |
fast_start_mttr_target |
300 |
|
|
|
|
MTTR target of forward crash recovery in seconds |
fast_start_parallel_rollback |
LOW |
|
|
|
|
max number of parallel recovery slaves that may be used |
file_mapping |
FALSE |
|
|
|
|
enable file mapping |
filesystemio_options |
|
|
|
|
|
IO operations on filesystem files |
fixed_date |
|
|
|
|
|
fixed SYSDATE value |
gc_files_to_locks |
|
|
|
|
|
mapping between file numbers and global cache locks (DFS) |
global_context_pool_size |
|
|
|
|
|
Global Application Context Pool Size in Bytes |
global_names |
FALSE |
|
|
|
|
enforce that database links have same name as remote database |
hash_area_size |
1048576 |
|
|
|
|
size of in-memory hash work area |
hash_join_enabled |
TRUE |
|
|
|
|
enable/disable hash join |
hi_shared_memory_address |
0 |
|
|
|
|
SGA starting address (high order 32-bits on 64-bit platforms) |
hs_autoregister |
TRUE |
|
|
|
|
enable automatic server DD updates in HS agent self-registration |
ifile |
|
|
|
|
|
include file in init.ora |
instance_groups |
|
|
|
|
|
list of instance group names |
instance_name |
oracle |
|
|
|
|
instance name supported by the instance |
instance_number |
0 |
|
|
|
|
instance number |
java_max_sessionspace_size |
0 |
|
|
|
|
max allowed size in bytes of a Java sessionspace |
java_pool_size |
33554432 |
|
|
|
|
size in bytes of the Java pool |
java_soft_sessionspace_limit |
0 |
|
|
|
|
warning limit on size in bytes of a Java sessionspace |
job_queue_processes |
10 |
|
|
|
|
number of job queue slave processes |
large_pool_size |
8388608 |
|
|
|
|
size in bytes of the large allocation pool |
license_max_sessions |
0 |
|
|
|
|
maximum number of non-system user sessions allowed |
license_max_users |
0 |
|
|
|
|
maximum number of named users that can be created in the databas |
license_sessions_warning |
0 |
|
|
|
|
warning level for number of non-system user sessions |
local_listener |
|
|
|
|
|
local listener |
lock_name_space |
|
|
|
|
|
lock name space used for generating lock names for standby/clone |
lock_sga |
FALSE |
|
|
|
|
Lock entire SGA in physical memory |
log_archive_dest |
|
|
|
|
|
archival destination text string |
log_archive_dest_1 |
|
|
|
|
|
archival destination #1 text string |
log_archive_dest_10 |
|
|
|
|
|
archival destination #10 text string |
log_archive_dest_2 |
|
|
|
|
|
archival destination #2 text string |
log_archive_dest_3 |
|
|
|
|
|
archival destination #3 text string |
log_archive_dest_4 |
|
|
|
|
|
archival destination #4 text string |
log_archive_dest_5 |
|
|
|
|
|
archival destination #5 text string |
log_archive_dest_6 |
|
|
|
|
|
archival destination #6 text string |
log_archive_dest_7 |
|
|
|
|
|
archival destination #7 text string |
log_archive_dest_8 |
|
|
|
|
|
archival destination #8 text string |
log_archive_dest_9 |
|
|
|
|
|
archival destination #9 text string |
log_archive_dest_state_1 |
enable |
|
|
|
|
archival destination #1 state text string |
log_archive_dest_state_10 |
enable |
|
|
|
|
archival destination #10 state text string |
log_archive_dest_state_2 |
enable |
|
|
|
|
archival destination #2 state text string |
log_archive_dest_state_3 |
enable |
|
|
|
|
archival destination #3 state text string |
log_archive_dest_state_4 |
enable |
|
|
|
|
archival destination #4 state text string |
log_archive_dest_state_5 |
enable |
|
|
|
|
archival destination #5 state text string |
log_archive_dest_state_6 |
enable |
|
|
|
|
archival destination #6 state text string |
log_archive_dest_state_7 |
enable |
|
|
|
|
archival destination #7 state text string |
log_archive_dest_state_8 |
enable |
|
|
|
|
archival destination #8 state text string |
log_archive_dest_state_9 |
enable |
|
|
|
|
archival destination #9 state text string |
log_archive_duplex_dest |
|
|
|
|
|
duplex archival destination text string |
log_archive_format |
ARC%S.%T |
|
|
|
|
archival destination format |
log_archive_max_processes |
2 |
|
|
|
|
maximum number of active ARCH processes |
log_archive_min_succeed_dest |
1 |
|
|
|
|
minimum number of archive destinations that must succeed |
log_archive_start |
FALSE |
|
|
|
|
start archival process on SGA initialization |
log_archive_trace |
0 |
|
|
|
|
Establish archivelog operation tracing level |
log_buffer |
524288 |
|
|
|
|
redo circular buffer size |
log_checkpoint_interval |
0 |
|
|
|
|
# redo blocks checkpoint threshold |
log_checkpoint_timeout |
1800 |
|
|
|
|
Maximum time interval between checkpoints in seconds |
log_checkpoints_to_alert |
FALSE |
|
|
|
|
log checkpoint begin/end to alert file |
log_file_name_convert |
|
|
|
|
|
logfile name convert patterns and strings for standby/clone db |
log_parallelism |
1 |
|
|
|
|
Number of log buffer strands |
logmnr_max_persistent_sessions |
1 |
|
|
|
|
maximum number of threads to mine |
max_commit_propagation_delay |
700 |
|
|
|
|
Max age of new snapshot in .01 seconds |
max_dispatchers |
5 |
|
|
|
|
max number of dispatchers |
max_dump_file_size |
UNLIMITED |
|
|
|
|
Maximum size (blocks) of dump file |
max_enabled_roles |
30 |
|
|
|
|
max number of roles a user can have enabled |
max_rollback_segments |
37 |
|
|
|
|
max. number of rollback segments in SGA cache |
max_shared_servers |
20 |
|
|
|
|
max number of shared servers |
mts_circuits |
170 |
|
|
|
|
max number of circuits |
mts_dispatchers |
(PROTOCOL=TCP) (SERVICE=oracleXDB) |
|
|
|
|
specifications of dispatchers |
mts_listener_address |
|
|
|
|
|
address(es) of network listener |
mts_max_dispatchers |
5 |
|
|
|
|
max number of dispatchers |
mts_max_servers |
20 |
|
|
|
|
max number of shared servers |
mts_multiple_listeners |
FALSE |
|
|
|
|
Are multiple listeners enabled? |
mts_servers |
1 |
|
|
|
|
number of shared servers to start up |
mts_service |
oracle |
|
|
|
|
service supported by dispatchers |
mts_sessions |
165 |
|
|
|
|
max number of shared server sessions |
object_cache_max_size_percent |
10 |
|
|
|
|
percentage of maximum size over optimal of the user session's ob |
object_cache_optimal_size |
102400 |
|
|
|
|
optimal size of the user session's object cache in bytes |
olap_page_pool_size |
33554432 |
|
|
|
|
size of the olap page pool in bytes |
open_cursors |
300 |
|
|
|
|
max # cursors per session |
open_links |
4 |
|
|
|
|
max # open links per session |
open_links_per_instance |
4 |
|
|
|
|
max # open links per instance |
optimizer_dynamic_sampling |
1 |
|
|
|
|
optimizer dynamic sampling |
optimizer_features_enable |
9.2.0 |
|
|
|
|
optimizer plan compatibility parameter |
optimizer_index_caching |
0 |
|
|
|
|
optimizer percent index caching |
optimizer_index_cost_adj |
100 |
|
|
|
|
optimizer index cost adjustment |
optimizer_max_permutations |
2000 |
|
|
|
|
optimizer maximum join permutations per query block |
optimizer_mode |
CHOOSE |
|
|
|
|
optimizer mode |
oracle_trace_collection_name |
|
|
|
|
|
Oracle TRACE default collection name |
oracle_trace_collection_path |
%ORACLE_HOME%\OTRACE\ADMIN\CDF\ |
|
|
|
|
Oracle TRACE collection path |
oracle_trace_collection_size |
5242880 |
|
|
|
|
Oracle TRACE collection file max. size |
oracle_trace_enable |
FALSE |
|
|
|
|
Oracle Trace enabled/disabled |
oracle_trace_facility_name |
oracled |
|
|
|
|
Oracle TRACE default facility name |
oracle_trace_facility_path |
%ORACLE_HOME%\OTRACE\ADMIN\FDF\ |
|
|
|
|
Oracle TRACE facility path |
os_authent_prefix |
OPS$ |
|
|
|
|
prefix for auto-logon accounts |
os_roles |
FALSE |
|
|
|
|
retrieve roles from the operating system |
parallel_adaptive_multi_user |
FALSE |
|
|
|
|
enable adaptive setting of degree for multiple user streams |
parallel_automatic_tuning |
FALSE |
|
|
|
|
enable intelligent defaults for parallel execution parameters |
parallel_execution_message_size |
2148 |
|
|
|
|
message buffer size for parallel execution |
parallel_instance_group |
|
|
|
|
|
instance group to use for all parallel operations |
parallel_max_servers |
5 |
|
|
|
|
maximum parallel query servers per instance |
parallel_min_percent |
0 |
|
|
|
|
minimum percent of threads required for parallel query |
parallel_min_servers |
0 |
|
|
|
|
minimum parallel query servers per instance |
parallel_server |
FALSE |
|
|
|
|
if TRUE startup in parallel server mode |
parallel_server_instances |
1 |
|
|
|
|
number of instances to use for sizing OPS SGA structures |
parallel_threads_per_cpu |
2 |
|
|
|
|
number of parallel execution threads per CPU |
partition_view_enabled |
FALSE |
|
|
|
|
enable/disable partitioned views |
pga_aggregate_target |
25165824 |
|
|
|
|
Target size for the aggregate PGA memory consumed by the instanc |
plsql_compiler_flags |
INTERPRETED |
|
|
|
|
PL/SQL compiler flags |
plsql_native_c_compiler |
|
|
|
|
|
plsql native C compiler |
plsql_native_library_dir |
|
|
|
|
|
plsql native library dir |
plsql_native_library_subdir_count |
0 |
|
|
|
|
plsql native library number of subdirectories |
plsql_native_linker |
|
|
|
|
|
plsql native linker |
plsql_native_make_file_name |
|
|
|
|
|
plsql native compilation make file |
plsql_native_make_utility |
|
|
|
|
|
plsql native compilation make utility |
plsql_v2_compatibility |
FALSE |
|
|
|
|
PL/SQL version 2.x compatibility flag |
pre_page_sga |
FALSE |
|
|
|
|
pre-page sga for process |
processes |
150 |
|
|
|
|
user processes |
query_rewrite_enabled |
FALSE |
|
|
|
|
allow rewrite of queries using materialized views if enabled |
query_rewrite_integrity |
enforced |
|
|
|
|
perform rewrite using materialized views with desired integrity |
rdbms_server_dn |
|
|
|
|
|
RDBMS's Distinguished Name |
read_only_open_delayed |
FALSE |
|
|
|
|
if TRUE delay opening of read only files until first access |
recovery_parallelism |
0 |
|
|
|
|
number of server processes to use for parallel recovery |
remote_archive_enable |
true |
|
|
|
|
remote archival enable setting |
remote_dependencies_mode |
TIMESTAMP |
|
|
|
|
remote-procedure-call dependencies mode parameter |
remote_listener |
|
|
|
|
|
remote listener |
remote_login_passwordfile |
EXCLUSIVE |
|
|
|
|
password file usage parameter |
remote_os_authent |
FALSE |
|
|
|
|
allow non-secure remote clients to use auto-logon accounts |
remote_os_roles |
FALSE |
|
|
|
|
allow non-secure remote clients to use os roles |
replication_dependency_tracking |
TRUE |
|
|
|
|
tracking dependency for Replication parallel propagation |
resource_limit |
FALSE |
|
|
|
|
master switch for resource limit |
resource_manager_plan |
|
|
|
|
|
resource mgr top plan |
rollback_segments |
|
|
|
|
|
undo segment list |
row_locking |
always |
|
|
|
|
row-locking |
serial_reuse |
DISABLE |
|
|
|
|
reuse the frame segments |
serializable |
FALSE |
|
|
|
|
serializable |
service_names |
oracle.apconsulting.zp.ua |
|
|
|
|
service names supported by the instance |
session_cached_cursors |
0 |
|
|
|
|
number of cursors to save in the session cursor cache |
session_max_open_files |
10 |
|
|
|
|
maximum number of open files allowed per session |
sessions |
170 |
|
|
|
|
user and system sessions |
sga_max_size |
135338868 |
|
|
|
|
max total SGA size |
shadow_core_dump |
partial |
|
|
|
|
Core Size for Shadow Processes |
shared_memory_address |
0 |
|
|
|
|
SGA starting address (low order 32-bits on 64-bit platforms) |
shared_pool_reserved_size |
2516582 |
|
|
|
|
size in bytes of reserved area of shared pool |
shared_pool_size |
50331648 |
|
|
|
|
size in bytes of shared pool |
shared_server_sessions |
165 |
|
|
|
|
max number of shared server sessions |
shared_servers |
1 |
|
|
|
|
number of shared servers to start up |
sort_area_retained_size |
0 |
|
|
|
|
size of in-memory sort work area retained between fetch calls |
sort_area_size |
524288 |
|
|
|
|
size of in-memory sort work area |
spfile |
%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA |
|
|
|
|
server parameter file |
sql92_security |
FALSE |
|
|
|
|
require select privilege for searched update/delete |
sql_trace |
FALSE |
|
|
|
|
enable SQL trace |
sql_version |
NATIVE |
|
|
|
|
sql language version parameter for compatibility issues |
standby_archive_dest |
%ORACLE_HOME%\RDBMS |
|
|
|
|
standby database archivelog destination text string |
standby_file_management |
MANUAL |
|
|
|
|
if auto then files are created/dropped automatically on standby |
star_transformation_enabled |
FALSE |
|
|
|
|
enable the use of star transformation |
statistics_level |
TYPICAL |
|
|
|
|
statistics level |
tape_asynch_io |
TRUE |
|
|
|
|
Use asynch I/O requests for tape devices |
thread |
0 |
|
|
|
|
Redo thread to mount |
timed_os_statistics |
0 |
|
|
|
|
internal os statistic gathering interval in seconds |
timed_statistics |
TRUE |
|
|
|
|
maintain internal timing statistics |
trace_enabled |
TRUE |
|
|
|
|
enable KST tracing |
tracefile_identifier |
|
|
|
|
|
trace file custom identifier |
transaction_auditing |
TRUE |
|
|
|
|
transaction auditing records generated in the redo log |
transactions |
187 |
|
|
|
|
max. number of concurrent active transactions |
transactions_per_rollback_segment |
5 |
|
|
|
|
number of active transactions per rollback segment |
undo_management |
AUTO |
|
|
|
|
instance runs in SMU mode if TRUE, else in RBU mode |
undo_retention |
10800 |
|
|
|
|
undo retention in seconds |
undo_suppress_errors |
FALSE |
|
|
|
|
Suppress RBU errors in SMU mode |
undo_tablespace |
UNDOTBS1 |
|
|
|
|
use/switch undo tablespace |
use_indirect_data_buffers |
FALSE |
|
|
|
|
Enable indirect data buffers (very large SGA on 32-bit platforms |
user_dump_dest |
E:\oracle\admin\oracle\udump |
|
|
|
|
User process dump directory |
utl_file_dir |
|
|
|
|
|
utl_file accessible directories list |
workarea_size_policy |
AUTO |
|
|
|
|
policy used to size SQL working areas (MANUAL/AUTO) |