Some Qns on Tuning - Urgent

[st2000]

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.

thanks

[marist89]

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.

[st2000]

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

[st2000]

also should we bounce the database.. after we do this..

[sambavan]

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.

V$sgastat
V$bgprocess
v$process
v$thread

and there are others which are inter-dependent on others.

Sam

[sambavan]

Yes you have to bounce after the changes.
Sam

[jgmagnus]

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.

- Magnus

[st2000]

Thanks for all the replies guys. But looks like everyone ignored the command for the changes..

[sambavan]

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

SVRMGRL> connect internal <----- make sure that
your ORACLE_SID=
is set in your enviromnet


SVRMGRL> shutdown immediate
SVRMGRL> startup

_______________________________________________

This should put the changes in place.

Sam

[marist89]

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.