init,ora file

[vijjenderm]

Hai ,

I have the below entries in init.ora file.
Is there any other important entries i missed here.
Recently we migrated from 7.3.4 to 8.0.6 , but we are facing noticable slowness, which worked better in 7.3.4.
So is there a way to tune , or we are missing any things in init file.
optimizer_mode = Choose

People say tyo analyze the tables, is there will any impact , can i know what will be the impact if we analyze,
once we analyze, if we dont want there can we set any patameter or unanalyse.


init .ora file

#---------------------------------------------------------------------------
ifile = /ora806/app/oracle/product/h/dbs/configsit01.ora
rollback_segments = (r01,r02,r03,r04)
db_files = 20
db_file_multiblock_read_count = 16
db_block_buffers = 8000
shared_pool_size = 18000000
log_checkpoint_interval = 307200
processes = 300
dml_locks = 200
log_buffer = 8192
sequence_cache_entries = 300
sequence_cache_hash_buckets = 23
timed_statistics = true
max_dump_file_size = 10240
distributed_transactions = 80
nls_date_format = "DD-MON-YYYY"
compatible = 8.0.6
#---------------------------------------------------------------------------


Thank,
vijay

[thanigai]

Hi Vijay,
setting parameters in init.ora file!!!!!!!
What kind of problem you are facing??>
Thanks.
Thanigaivasan.

[pravin]

sort_area_size parameter is not there.

most important - archiving features do u want archiving or noarchiving.

what is the exact problem u are getting

[SANJAY_G]

Is it the complete listing of parameter file? I don't see db_block_size ??

How much db buffer do you have? and what are the buffer hit ratios?

Sanjay