Re: Addressing buffer buisy waits in 10g with ASSM
From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Sun, 16 Sep 2012 20:38:57 +0200
Message-ID: <CAA9w=EsHi+2qoU2-Dmk3Kfy+LLbAbApjYFvVLrHZTA41QQ0bkQ_at_mail.gmail.com>
Study this:
https://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait
Date: Sun, 16 Sep 2012 20:38:57 +0200
Message-ID: <CAA9w=EsHi+2qoU2-Dmk3Kfy+LLbAbApjYFvVLrHZTA41QQ0bkQ_at_mail.gmail.com>
Study this:
https://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-busy-wait
and see if that helps you.
On Sun, Sep 16, 2012 at 6:48 PM, Saad Khan <saad4u_at_gmail.com> wrote:
> Hi all,
> We've a Oracle 10gR2 environment on AIX 6.1. I'm seeing a lot of buffer
> buisy waits and mostly on data segment headers. When I try to add more
> freelists to the buisy segments, it doesnt let me do that being in ASSM
> mode.
>
> What are the other options that I can utilize in overcoming this?
>
> Any help is appreciated.
>
> Thanks.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Toon Koppelaars RuleGen BV Toon.Koppelaars_at_RuleGen.com www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text -- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 16 2012 - 13:38:57 CDT