Mike,<br><br>First of all, thanks for your reply to my rollback question. I have copied my init.ora file below. I don't see the line you mentioned, so I will add it in at the end. Is that a good spot for it? <br><br>Also, I am pretty new at installing Oracle. How do I know if the other settings in this file are set right for my database? I know that is a very broad question and you may not have the time to answer it. Maybe you could point me towards a book or web page that might enlighten me.<br><br>Thanks again...<br><br><b><br>#<br># $Header: init.ora 1.2 94/10/18 16:12:36 gdudey Osd<desktop/netware> $ init.ora Copyr (c) 1991 Oracle<br>#<br>##############################################################################<br># Example INIT.ORA file<br>#<br># This file is provided by Oracle Corporation to help you customize<br># your RDBMS installation for your site. Important system parameters<br># are discussed, and example settings given.<br>#<br># Some parameter settings are generic to any size installation.<br># For parameters that require different values in different size<br># installations, three scenarios have been provided: SMALL, MEDIUM<br># and LARGE. Any parameter that needs to be tuned according to<br># installation size will have three settings, each one commented<br># according to installation size.<br>#<br># Use the following table to approximate the SGA size needed for the<br># three scenarious provided in this file:<br>#<br># -------Installation/Database Size------<br># SMALL MEDIUM LARGE<br># Block 2K 4500K 6800K 17000K<br># Size 4K 5500K 8800K 21000K<br>#<br># To set up a database that multiple instances will be using, place<br># all instance-specific parameters in one file, and then have all<br># of these files point to a master file using the IFILE command.<br># This way, when you change a public<br># parameter, it will automatically change on all instances. This is<br># necessary, since all instances must run with the same value for many<br># parameters. For example, if you choose to use private rollback segments,<br># these must be specified in different files, but since all gc_*<br># parameters must be the same on all instances, they should be in one file.<br>#<br># INSTRUCTIONS: Edit this file and the other INIT files it calls for<br># your site, either by using the values provided here or by providing<br># your own. Then place an IFILE= line into each instance-specific<br># INIT file that points at this file.<br>###############################################################################<br><br>db_name = oracle<br>db_files = 20<br>control_files = (D:\ORANT\DATABASE\ctl1orcl.ora, D:\ORANT\DATABASE\ctl2orcl.ora)<br><br>compatible = 7.3.0.0.0<br><br>db_file_multiblock_read_count = 8 # INITIAL<br># db_file_multiblock_read_count = 8 # SMALL<br># db_file_multiblock_read_count = 16 # MEDIUM<br># db_file_multiblock_read_count = 32 # LARGE<br><br>db_block_buffers = 200 # INITIAL<br># db_block_buffers = 200 # SMALL<br># db_block_buffers = 550 # MEDIUM<br># db_block_buffers = 3200 # LARGE<br><br>shared_pool_size = 6500000 # INITIAL<br># shared_pool_size = 3500000 # SMALL<br># shared_pool_size = 6000000 # MEDIUM<br># shared_pool_size = 9000000 # LARGE<br><br>log_checkpoint_interval = 10000<br><br>processes = 50 # INITIAL<br># processes = 50 # SMALL<br># processes = 100 # MEDIUM<br># processes = 200 # LARGE<br><br>dml_locks = 100 # INITIAL<br># dml_locks = 100 # SMALL<br># dml_locks = 200 # MEDIUM<br># dml_locks = 500 # LARGE<br><br>log_buffer = 8192 # INITIAL<br># log_buffer = 8192 # SMALL<br># log_buffer = 32768 # MEDIUM<br># log_buffer = 163840 # LARGE<br><br>sequence_cache_entries = 10 # INITIAL<br># sequence_cache_entries = 10 # SMALL<br># sequence_cache_entries = 30 # MEDIUM<br># sequence_cache_entries = 100 # LARGE<br><br>sequence_cache_hash_buckets = 10 # INITIAL<br># sequence_cache_hash_buckets = 10 # SMALL<br># sequence_cache_hash_buckets = 23 # MEDIUM<br># sequence_cache_hash_buckets = 89 # LARGE<br><br># audit_trail = true # if you want auditing<br># timed_statistics = true # if you want timed statistics<br>max_dump_file_size = 10240 # limit trace file size to 5 Meg each<br><br># log_archive_start = true # if you want automatic archiving<br><br># define directories to store trace and alert files<br>background_dump_dest=%RDBMS73%\trace<br>user_dump_dest=%RDBMS73%\trace<br><br>db_block_size = 2048<br><br>snapshot_refresh_processes = 1<br><br>remote_login_passwordfile = shared<br><br>text_enable = true<br>unlimited_rollback_segments = true<br></b><br><br> <p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>