# Akadia AG, Zieglerstrasse 34, CH-3007 Bern initSOL1.ora # -------------------------------------------------------------------------- # File: initSOL1.ora # # Autor: Martin Zahn Akadia AG 11.08.99 (Tag der Sonnenfinsternis) # # Purpose: Instance configuration parameters for SOL1 database # # Location: $ORACLE_HOME/dbs # # Certified: Oracle 7.3.4.4 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 = SOL1 db_domain = world ### Basic Configuration Parameters ### ------------------------------ compatible = 7.3.4.4 db_block_size = 4096 db_files = 512 log_files = 128 control_files = /u01/db/SOL1/con/SOL1_con01.con, /oracle/ctrl/SOL1/SOL1_con02.con ### Database Buffer Cache, I/O ### -------------------------- db_block_buffers = 5000 db_block_lru_extended_statistics = 0 db_block_lru_statistics = false db_file_simultaneous_writes = 4 db_file_multiblock_read_count = 32 ### Database Library Cache ### ---------------------- shared_pool_size = 5000000 shared_pool_reserved_size = 200000 shared_pool_reserved_min_alloc = 5000 ### Checkpointing ### ------------- db_block_checkpoint_batch = 8 log_checkpoint_interval = 20000000 log_checkpoint_timeout = 0 log_checkpoints_to_alert = false checkpoint_process = true ### REDO Logging ### ------------ log_buffer = 5120000 log_archive_start = false log_archive_dest = /u01/db/SOL1/arc log_archive_format = SOL1_%s.arc log_archive_buffers = 5 log_archive_buffer_size = 64 ### 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 sequence_cache_entries = 32 optimizer_mode = choose partition_view_enabled = true hash_join_enabled = true hash_area_size = 1024000 hash_multiblock_io_count = 16 always_anti_join = hash ### Sorting ### ------- sort_area_retained_size = 128000 sort_area_size = 512000 sort_direct_writes = auto ### Traces, Dumps & Statistics ### -------------------------- audit_file_dest = /u01/db/SOL1/adm/admp user_dump_dest = /u01/db/SOL1/adm/bdmp background_dump_dest = /u01/db/SOL1/adm/cdmp core_dump_dest = /u01/db/SOL1/adm/udmp utl_file_dir = /u01/db/SOL1/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=SOL1))" mts_listener_address = "(address=(protocol=tcp)(host=quorum)(port=1521))" mts_service = SOL1 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 = 60 job_queue_processes = 1 job_queue_keep_connections = true ### Processes, Transactions, User Licensing, Locks ### ---------------------------------------------- processes = 30 license_max_sessions = 0 # Licensing is not enforced license_sessions_warning = 0 # No warning when limit is reached enqueue_resources = 4096 unlimited_rollback_segments = true ### Parallel Query Option ### --------------------- parallel_min_servers = 0 parallel_max_servers = 0 parallel_server_idle_time = 0