As for oracle I have noticed that on the NEW Server oracle is constantly using on avg about 30-40% of the processor, Also when we run some batch queries it kills oracle, the processor usage goes off the charts and as u the result is oracle comes to grind crawl and the phone start ringing about evolution being slow. Which it didn’t do that on the old system (OLD). I have looked at spfiles configuration and have a few questions about the differences. OLD Server *.db_block_size=4096 *.db_cache_size=618659840 *.log_archive_dest='f:\oracle\archive\' ***Not In File*** *.pga_aggregate_target=205520896 *.processes=250 *.shared_pool_size=205520896 NEW Server *.db_block_size=8192 *.db_cache_size=559939584 *.log_archive_dest_1='LOCATION=e:\oradata\mtmsdbev\archive' *.log_archive_format='%t_%s.dbf' *.pga_aggregate_target=498073600 *.processes=150 *.shared_pool_size=186646528 My questions are: 1. Can we up the processes=250 which is the max? 2. Can we also change the %t_%s.dbf to the .arc file type? From my research there isnt any downside to change archive format, but my concern is that since .dbf files are databse files they are complex and need more resources to create then creating the .arc files. 3. We definitly need to change the archive location.