async i/o problem..

[anandkl]

Hi Friends,
We have our production database on cluster and due to Async i/o problem the database keeps failing over to other database.Can you please suggestion me some solution for this.
Actually i am thinking of setting DBWR_IO_SLAVES parameter.But i heard there are cpu degradation when set this parameter.Also please let me know do i need to make any changes at the OS level.
I am running oracle 8.1.6 on sun solaris 2.7.

regards
anandkl

[aarroyob]

We had same problem in solaris 2.6 and oracle 8.1.7 with volume manager. The problem was a bug using volume manager with 2.6. After apply the last patch the problem was solved.

The other workarround submitted by oracle was:

db_writer_processes=1
dbwr_io_slaves>0
disk_async_io=false

But we have not tested.

Hope that helps

Angel

[anandkl]

Thanks for the reply, actually i was also planing for the same thing.But i was told that setting these parameters would degrade the performance of the CPU,Is it true.

please mail back

regards
anandkl

[aarroyob]

At theory level it will do the same thing. Dbwr_io_slaves will simulate async_io. But practical i have never tested.

Cheers

Angel