# Akadia AG, Zieglerstrasse 34, CH-3007 Bern # ---------------------------------------------------------------------- # # File: initPARA.ora # # Autor: Martin Zahn / 10.07.1998 # # Purpose: Instance configuration parameters for PARA database # # Location: $ORACLE_HOME\Database # # Certified: Oracle V.7.3.3 on Windows-NT # ---------------------------------------------------------------------- ### Basic Configuration Parameters ### ------------------------------ db_name = PARA global_names = TRUE db_domain = akadia.ch compatible = 7.3.3.0.0 control_files = E:\Oradata\PARA\PARA_con01.con, E:\Oradata\PARA\PARA_con02.con, E:\Oradata\PARA\PARA_con03.con ### Database Buffer Cache, I/O ### -------------------------- db_block_buffers = 1500 db_block_size = 4096 db_files = 25 db_file_multiblock_read_count = 16 ### UNDO Logging ### ------------ rollback_segments = (RB01,RB02,RB03,RB04,RB05,RB06) ### Checkpointing ### ------------- log_checkpoint_timeout = 0 log_checkpoint_interval = 10000 ### REDO Logging ### ------------ log_buffer = 163840 checkpoint_process = false log_archive_start = false log_archive_dest = E:\Oradata\PARA\arc log_archive_format = "ARC_%S.arc" ### Database Library Cache ### ---------------------- shared_pool_size = 15000000 ### SQL Processing, Optimizer, Sequences ### ------------------------------------ processes = 20 dml_locks = 500 sequence_cache_entries = 100 sequence_cache_hash_buckets = 89 open_cursors = 512 session_cached_cursors = 10 ### Sorting ### ------- sort_area_retained_size = 131072 # From Oracle EXPERT sort_area_size = 131072 # From Oracle EXPERT ### User Management-Parameter ### ------------------------- max_enabled_roles = 100 os_authent_prefix = OPS$ remote_os_authent = false max_enabled_roles = 100 ### DDB- und DBMS_JOB-Parameter ### --------------------------- job_queue_interval = 30 job_queue_keep_connections = FALSE job_queue_processes = 2 remote_login_passwordfile = exclusive dblink_encrypt_login = true ### MTS-Configuration ### ----------------- # NT is already multithreaded, so we don't need the Oracle MTS option. # If you configure it, Oracle simply ignores the mts parameters in the # init.ora parameter file ### NLS-Parameter ### ------------- nls_date_format = 'DD MM YYYY' nls_numeric_characters = '.,' ### Optimizer-Parameter ### ------------------- optimizer_mode = choose hash_join_enabled = true always_anti_join = Hash hash_area_size = 265000 # 2 * SORT_AREA_SIZE partition_view_enabled = true v733_plans_enabled = true ### PL/SQL File I/O ### --------------- utl_file_dir = C:\temp ### Traces, Dumps & Statistics ### -------------------------- background_dump_dest = E:\Oradata\PARA\TRACE\bg user_dump_dest = E:\Oradata\PARA\TRACE\fg timed_statistics = true sql_trace = false max_dump_file_size = 10240