Re: very slow archivelogs write
From: <johnbhurley_at_sbcglobal.net>
Date: Thu, 19 Mar 2009 10:17:25 -0700 (PDT)
Message-ID: <c4fb2424-04e3-448a-8e0d-8f36dd601b2d_at_z9g2000yqi.googlegroups.com>
On Mar 19, 1:00 pm, "hehehe" <m..._at_m.ccc> wrote:
> Hello!
>
> I have archivelog enabled on my oracle 9 database. I have 2 destionations
> of my arch local and remote. When all redologs full and remote destionation
> is enabled database hang until finished copy archivelog to remote. But when
> i turn off remote dest when redologs full nothing happend. So this must be a
> problem with my remote dest. I have :
> log_archive_dest_3 service=test optional reopen=10
>
> Link beetwen local and remote = 4M/bit. Size 10xredo - 64MB
>
> Any idea how to resolve?
>
> Regards
Date: Thu, 19 Mar 2009 10:17:25 -0700 (PDT)
Message-ID: <c4fb2424-04e3-448a-8e0d-8f36dd601b2d_at_z9g2000yqi.googlegroups.com>
On Mar 19, 1:00 pm, "hehehe" <m..._at_m.ccc> wrote:
> Hello!
>
> I have archivelog enabled on my oracle 9 database. I have 2 destionations
> of my arch local and remote. When all redologs full and remote destionation
> is enabled database hang until finished copy archivelog to remote. But when
> i turn off remote dest when redologs full nothing happend. So this must be a
> problem with my remote dest. I have :
> log_archive_dest_3 service=test optional reopen=10
>
> Link beetwen local and remote = 4M/bit. Size 10xredo - 64MB
>
> Any idea how to resolve?
>
> Regards
Setup like 10 online logs so that when your system switches from one to another online log you don't wait. Only when all of the spaces is used up for the mandatory destinations ( if more than one ) and all of the online logs need to be archived will your system hang.
Read the oracle documentation http://tahiti.oracle.com ...
Lots of good answers here in this forum if you search the questions that have already been asked and answered. Similarly use asktom.oracle.com ... Received on Thu Mar 19 2009 - 12:17:25 CDT