Re: Addressing buffer buisy waits in 10g with ASSM

From: Saad Khan <saad4u_at_gmail.com>
Date: Mon, 17 Sep 2012 12:40:25 -0400
Message-ID: <CACqGOPJMBMUG6GMHF=Na9xHRacrfx3fhR7h9aDtAAEPZKnQCHw_at_mail.gmail.com>

Thanks for such a informative link but its asking to partition indexes if there are buffer buisy waits on indexes (which there are in my case). Right now I'm not in a position to partition any segments. Any other ideas?

Help appreciated.

On Sun, Sep 16, 2012 at 2:38 PM, Toon Koppelaars < toon.koppelaars_at_rulegen.com> wrote:

> 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-l

Received on Mon Sep 17 2012 - 11:40:25 CDT