db_name = abc lock_sga = false db_block_size = 8192 db_files = 1000 control_files = (/v001/abc/ctrl_1.ctl, /v002/abc/ctrl_2.ctl, /v001/abc/ctrl_3.ctl, /v002/abc/ctrl_4.ctl) # Below for possible future use... # init_sql_files = (?/dbs/sql.bsq, # ?/rdbms/admin/catalog.sql, # ?/rdbms/admin/expvew.sql) rollback_segments = (r01,r02,r03,r04,r05,r06) utl_file_dir = * background_dump_dest = /oracle/admin/abc/bdump core_dump_dest = /oracle/admin/abc/cdump user_dump_dest = /oracle/admin/abc/udump db_block_buffers = 32768 shared_pool_size =134217728 sort_area_size = 1000000 log_buffer = 11534336 java_pool_size = 50000000 db_file_multiblock_read_count = 16 log_archive_dest = /abc/varc/archv log_archive_format = %S.log log_archive_start = true timed_statistics = true # sql_trace = true processes = 200 open_cursors = 400 dml_locks = 500 max_enabled_roles = 96 job_queue_processes = 5 log_checkpoint_interval = 12000000 max_dump_file_size = 1024 db_writer_processes = 2 # 1 per spindle # mts_dispatchers = "tcp,2" # mts_max_dispatchers = 10 # mts_servers = 1 # mts_max_servers = 10 # mts_service = se601 # mts_listener_address = "(ADDRESS=(PROTOCOL=tcp)(KEY=abc))" # # mts_listener_address= "(ADDRESS=(PROTOCOL=tcp) # (HOST=se601)(PORT=1521))"