# Akadia AG, Arvenweg 4, CH-3604 Thun initSMA1.ora # ---------------------------------------------------------------------- # # File: initSMA1.ora # # Autor: Martin Zahn / 10.12.2000 # # Purpose: Instance configuration parameters # # Location: $ORACLE_HOME\Database # # Certified: Oracle V.8.1.7 on Windows-NT # ---------------------------------------------------------------------- ### Global Naming ### ------------- # Enforce that a dblink has same name as the db it connects to global_names = TRUE ### Global database name is db_name.db_domain ### ----------------------------------------- db_name = SMA1 db_domain = WORLD ### Automatic Instance Registration ### ------------------------------- # Service registration, which provides the listener with instance information # such as database service names and instance names. instance_name = SMA1 service_names = SMA1 ### Basic Configuration Parameters ### ------------------------------ compatible = 8.1.7.0 db_block_size = 4096 db_files = 512 control_files = C:\Oradata\SMA1\ctl\SMA1_con01.con, D:\Oradata\SMA1\ctl\SMA1_con02.con ### Database Buffer Cache, I/O ### -------------------------- db_block_buffers = 5000 db_file_multiblock_read_count = 32 ### Database Block Checking ### ----------------------- ### log_block_checksum is no more supported db_block_checking = true db_block_checksum = false ### Automatic Tuning of parallel Query and DML statements ### ----------------------------------------------------- # # Caution ! # # Be very careful when you set this parameter in OLTP and Hybrid Systems. # This Parameter is mainly used for DSS Systems. # Read chapter 26 "Tuning Parallel Execution" in the Oracle Tuning Guide. # # SHARED_POOL_SIZE: Set to a large value, including the # space required for parallel execution. # # LARGE_POOL_SIZE: Unset (defaults to a large value that includes # the space required for parallel execution). # # This is for automatic parallel tuning enabled # parallel_automatic_tuning = true # shared_pool_size = 5000000 # This are the normal parameters parallel_automatic_tuning = false shared_pool_size = 10000000 # This are the necessary parameters for JAVA development # parallel_automatic_tuning = false # shared_pool_size = 200000000 # java_pool_size = 100000000 ### Checkpointing ### ------------- log_checkpoint_interval = 50000000 log_checkpoint_timeout = 0 log_checkpoints_to_alert = true ### REDO Logging ### ------------ log_buffer = 1024000 log_archive_start = false log_archive_dest = D:\Oradata\SMA1\arc log_archive_format = SMA1_%s.arc ### Multiplexing REDO Logging ### ---------------------- ### You cannot use LOG_ARCHIVE_DEST_x with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST # log_archive_dest_1 = "location=D:\Oradata\SMA1\arc1 mandatory reopen=300" # log_archive_dest_2 = "location=D:\Oradata\SMA1\arc2 mandatory reopen=300" # log_archive_dest_3 = "location=D:\Oradata\SMA1\arc3 mandatory reopen=300" # log_archive_dest_4 = "location=D:\Oradata\SMA1\arc4 optional reopen=300" # log_archive_dest_5 = "location=D:\Oradata\SMA1\arc5 optional reopen=300" # log_archive_min_succeed_dest = 4 ### UNDO Logging ### ------------ max_rollback_segments = 50 rollback_segments = (rbs01,rbs02,rbs03,rbs04,rbs05,rbs06) ### SQL Processing, Optimizer, Sequences ### ------------------------------------ open_cursors = 1024 cursor_space_for_time = false optimizer_mode = choose partition_view_enabled = true hash_join_enabled = true hash_area_size = 1024000 hash_multiblock_io_count = 16 always_anti_join = hash db_file_direct_io_count = 128 ### Sorting ### ------- sort_area_retained_size = 128000 sort_area_size = 512000 ### Traces, Dumps & Statistics ### -------------------------- user_dump_dest = D:\Oradata\SMA1\Adm\udmp background_dump_dest = D:\Oradata\SMA1\Adm\bdmp user_dump_dest = D:\Oradata\SMA1\Adm\udmp utl_file_dir = D:\Oradata\SMA1\Adm\utld max_dump_file_size = 10240 _trace_files_public = true sql_trace = false timed_statistics = true ### Resource Limiter, Security & Auditing ### ------------------------------------- sql92_security = true resource_limit = true audit_trail = none max_enabled_roles = 128 os_authent_prefix = "OPS$" os_roles = false remote_os_roles = false remote_os_authent = true 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 ### Distributed Operations ### ---------------------- distributed_transactions = 250 open_links = 64 ### Job Queues ### ---------- job_queue_interval = 3600 job_queue_processes = 1 ### Processes, Transactions, User Licensing, Locks ### ---------------------------------------------- processes = 30 license_max_sessions = 0 license_sessions_warning = 0 enqueue_resources = 4096 ### Parallel Query Option ### --------------------- parallel_min_servers = 2 parallel_max_servers = 5 # SMALL # parallel_max_servers = 4 x (number of CPUs) # MEDIUM # parallel_max_servers = 4 x (number of CPUs) # LARGE ### Query Rewrite for Materialized Views, Function based Indexes ### ------------------------------------------------------------ # query_rewrite_integrity = [enforced,trusted,stale_tolerated] # query_rewrite_enabled = true query_rewrite_integrity = stale_tolerated ### NLS Default Settings ### -------------------- nls_date_format = 'DD.MM.YYYY' nls_numeric_characters = '.,' nls_language = AMERICAN nls_territory = AMERICA ### Oracle Trace ### ------------ # Uncomment the following line if you wish to enable the Oracle Trace product # to trace server activity. This enables scheduling of server collections # from the Oracle Enterprise Manager Console. # Also, if the oracle_trace_collection_name parameter is non-null, # every session will write to the named collection, as well as enabling you # to schedule future collections from the console. oracle_trace_enable = FALSE ### Event Tracing ### ------------- # Sets integrity checking for tables # event = "10210 trace name context forever, level 10" # Sets integrity checking for indexes # event = "10211 trace name context forever, level 10" # Allows export to extract all data, except the corrupted blocks # event = "10231 trace name context forever, level 10" # Identify corrupted rollback segment when database cannot be started # event = "10015 trace name context forever"