# Akadia AG, Arvenweg 4, CH-3604 Thun initDIA3.ora # -------------------------------------------------------------------------- # File: initDIA3.ora # # Autor: Martin Zahn Akadia AG 25.08.2000 # # Purpose: Instance configuration parameters for DIA3 database # # Location: $ORACLE_HOME/dbs # # Certified: Oracle 8.1.7 on SUN Solaris 2.7 # -------------------------------------------------------------------------- ### 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 = DIA3 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 = DIA3 service_names = DIA3,PROD ### Basic Configuration Parameters ### ------------------------------ compatible = 8.1.7.0 db_block_size = 4096 db_files = 512 control_files = /u01/db/DIA3/con/DIA3_con01.con, /u02/db/DIA3/con/DIA3_con02.con, /u03/db/DIA3/con/DIA3_con03.con ### Database Buffer Cache, I/O ### -------------------------- db_block_buffers = 12000 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 = /u01/db/DIA3/arc log_archive_format = DIA3_%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/DIA3/arc1 mandatory reopen=300" # log_archive_dest_2 = "location=/u01/db/DIA3/arc2 mandatory reopen=300" # log_archive_dest_3 = "location=/u01/db/DIA3/arc3 mandatory reopen=300" # log_archive_dest_4 = "location=/u01/db/DIA3/arc4 optional reopen=300" # log_archive_dest_5 = "location=/u01/db/DIA3/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/DIA3/adm/admp user_dump_dest = /u01/db/DIA3/adm/udmp background_dump_dest = /u01/db/DIA3/adm/bdmp core_dump_dest = /u01/db/DIA3/adm/cdmp utl_file_dir = /u01/db/DIA3/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_service = PPB mts_listener_address = "(address=(protocol=ipc)(key=DIA3))" mts_listener_address = "(address=(protocol=tcp)(host=diamond)(port=1523))" mts_dispatchers = "(address=(partial=true)(protocol=tcp)(host=diamond))(dispatchers=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 # 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"