Re: very slow archivelogs write

From: <sybrandb_at_hccnet.nl>
Date: Thu, 19 Mar 2009 23:18:27 +0100
Message-ID: <v1h5s4ppc4n4rvcbceokhh86utoa7mgvdp_at_4ax.com>

On Thu, 19 Mar 2009 18:00:50 +0100, "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
>

The behavior you describe is by design. As you only specify 'Oracle 9' database, which is very inaccurate, I can only mention in 9.2.0.7 a parameter was added to change this behavior.

Other than that, obviously increasing bandwith should resolve the problem.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Mar 19 2009 - 17:18:27 CDT