async i/o problem..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: async i/o problem..

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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
    anandkl

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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
    anandkl

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    At theory level it will do the same thing. Dbwr_io_slaves will simulate async_io. But practical i have never tested.

    Cheers

    Angel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width