Metrics for db_writer_processes effectiveness
We want to increase the number db writers on our RAC database 10.2.0.4 to 4.Currently we have the db_writer_peocesses=1 .
What metrices or parameters can I use to determine if increasing the number of db_writer_processes is effective?
Any parameters from the Operating system or database itself.Any scripts or ideas will be appreciated.
What metrices or parameters can I use to determine if increasing the number of db_writer_processes is effective?
Any parameters from the Operating system or database itself.Any scripts or ideas will be appreciated.
Austin
0