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 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.
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.