-
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
-
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.
Jeff Hunter
-
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.
V$sgastat
V$bgprocess
v$process
v$thread
and there are others which are inter-dependent on others.
Sam
-
Yes you have to bounce after the changes.
Sam
-
rember
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
-
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
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
-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|