|
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) |