# Akadia AG, Zieglerstrasse 34, CH-3007 Bern initSOL3.ora # -------------------------------------------------------------------------- # File: initSOL3.ora # # Autor: Martin Zahn Akadia AG 11.08.99 (Tag der Sonnenfinsternis) # # Purpose: Instance configuration parameters for SOL3 database # # Location: $ORACLE_HOME/dbs # # Certified: Oracle 8.1.5 on SUN Solaris 2.6 # -------------------------------------------------------------------------- ### Global Naming ### ------------- # Enforce that a dblink has same name as the db it connects to global_names = TRUE # Edit and uncomment the following line to provide the suffix that will be # appended to the db_name parameter (separated with a dot) and stored as the # global database name when a database is created. If your site uses # Internet Domain names for e-mail, then the part of your e-mail address after # the '@' is a good candidate for this parameter value. # db_domain = us.acme.com # global database name is db_name.db_domain db_name = SOL3 db_domain = WORLD instance_name = SOL3 service_names = SOL3.WORLD ### Basic Configuration Parameters ### ------------------------------ compatible = 8.1.5.1.0 db_block_size = 4096 db_files = 512 control_files = /u01/db/SOL3/con/SOL3_con01.con, /oracle/ctrl/SOL3/SOL3_con02.con ### Database Buffer Cache, I/O ### -------------------------- db_block_buffers = 10000 db_file_multiblock_read_count = 32 ### Database Block Checking ### ----------------------- ### log_block_checksum is no more supported db_block_checking = true db_block_checksum = false ### Database Library Cache ### ---------------------- shared_pool_size = 10000000 ### 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 = /u01/db/SOL3/arc log_archive_format = SOL3_%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=/u01/db/SOL3/arc1 mandatory reopen=300" # log_archive_dest_2 = "location=/u01/db/SOL3/arc2 mandatory reopen=300" # log_archive_dest_3 = "location=/u01/db/SOL3/arc3 mandatory reopen=300" # log_archive_dest_4 = "location=/u01/db/SOL3/arc4 optional reopen=300" # log_archive_dest_5 = "location=/u01/db/SOL3/arc5 optional reopen=300" # log_archive_min_succeed_dest = 4 ### UNDO Logging ### ------------ max_rollback_segments = 50 rollback_segments = (rbs01,rbs02,rbs03,rbs04,rbs05, rbs06,rbs07,rbs08,rbs09,rbs10, rbs11,rbs12,rbs13,rbs14,rbs15, rbs16,rbs17,rbs18,rbs19,rbs20) ### 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 ### -------------------------- audit_file_dest = /u01/db/SOL3/adm/admp user_dump_dest = /u01/db/SOL3/adm/bdmp background_dump_dest = /u01/db/SOL3/adm/cdmp core_dump_dest = /u01/db/SOL3/adm/udmp utl_file_dir = /u01/db/SOL3/adm/utl 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 = false remote_login_passwordfile = none dblink_encrypt_login = true ### Multi-Threaded Server ### --------------------- mts_multiple_listeners = false mts_listener_address = "(address=(protocol=ipc)(key=SOL3))" mts_listener_address = "(address=(protocol=tcp)(host=quorum)(port=1523))" mts_service = SOL3 mts_dispatchers = "ipc, 1" mts_dispatchers = "tcp, 2" mts_max_dispatchers = 20 mts_servers = 1 mts_max_servers = 20 ### 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 # parallel_max_servers = 4 x (number of CPUs) # MEDIUM # parallel_max_servers = 4 x (number of CPUs) # LARGE ### Function based Indexes ### ---------------------- query_rewrite_enabled = true query_rewrite_integrity = trusted ### 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"