I have a question regards to some Tuning.
Basically we have sun 450 server with 2 processes.
We want to do some appln/system tuning
how do i increase db_writer_processes from 1 to 2(what is the max)
how do i increase the log_writer processes (aswell) what is the parameter.. i could not find in show parameters log.
similarly what are all the views involved for this kind of query or situation.
You can change the number of db writers by changing the db_writer_processes parameter. Keep in mind, you must also change the db_block_lru_latches at the same time.
how do you change the same. Alter session, system ?? How ??
secondly, how about log_writer_process ??
as well could you also give me what are the views available for the same??
Thanks for the reply Marist89
also should we bounce the database.. after we do this..
The range for the db_writer_processes = 1-10
You have to set the number of processes that you want to be started, in the init<SID>.ora file that could be found under the $ORACLE_BASE/admin/<sid>/pfile
I'm not aware of whether there is a way to increase the log_writer processes. I beleive that it was an dynamic parameter whose number gets decided by oracle. If your system is in the archive mode then, you could set a max limit on the archiver processes.
and there are others which are inter-dependent on others.
Yes you have to bounce after the changes.
you need to add these changes in your init.ora file, if you change them dynamically (alter session/system) and then bounce the DB you will not have your changes there. Once you change your init.ora parameter file, then bounce the DB and yer all set.
Thanks for all the replies guys. But looks like everyone ignored the command for the changes..
what command do you need.
To perform the changes go to the initSID.ora file add the
db_writer_process = 2
save that file
come to the prompt,
SVRMGRL> connect internal <----- make sure that
is set in your enviromnet
SVRMGRL> shutdown immediate
This should put the changes in place.
There is no command to make these changes on-the-fly.
You must change your init.ora parameter and then bounce the database (shutdown/startup) in order for the changes to take effect.
Click Here to Expand Forum to Full Width