increasinf : db_writer_processes

[pr_srinivas]

How can increase db_writer_processes in ORACLE DATABASE & How can i find out the existing parameter value for it

Rgds

PR

[markus_doehr2 · Accepted solution]

Use

brtools

--> Instance management

--> Alter database parameter

--> Change parameter value

There you can have a look at the actual value and increase it.

--

Markus

[Former Member]

because of the capability of asynchronious I/O.

[Former Member]

as orasid

sqlplus> show parameter db_writer_processes

sqlplus>alter system set db_writer_processes=xx scope=spfile;

If you are not using spfile modify the value manually in initSID.ora

The parameter is not dynamic it will take effect after the DB restart

Thanks,