Re: Newbie: EZ Performance Tuning?

Here's an init.ora for a 256M based on the book "oracle performanace tuning tips and techniques" by richard niemiec. db_buffer_block = 8192
db_block_buffers = 5000
shared_pool_size = 20000000
log_checkpoint_interval = 0 * 100000 dml_locks = 1000
processes = 200
log_buffer = 327680
row_cache_cursor = 200
open_cursor = 600
sort_area_size = 2000000
max_dump_file_size = 10240
db_files = 1022
dbwr_io_slaves = 4 * never have used checkpoint_process = true
optmizer_mode = choose
timed_statistics = true

• personal experience the author says this example was for a 2.5G database on a server with 256M of memory... this sould be a good starting point there's a lot more tuning that can be done, but this should get you started. terry, illinois power
• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!