Re: ASSM bug: slow INSERT after uncomitted DELETE
From: Helma <helma.vinke_at_hotmail.com>
Date: Tue, 11 Aug 2009 02:06:05 -0700 (PDT)
Message-ID: <871b6cbc-bb50-4bba-948e-583e513b256b_at_o32g2000yqm.googlegroups.com>
On Aug 11, 9:10 am, ca111026 <ca111..._at_gmail.com> wrote:
> Sorry, how buffer busy waits are related to ASSM?
Date: Tue, 11 Aug 2009 02:06:05 -0700 (PDT)
Message-ID: <871b6cbc-bb50-4bba-948e-583e513b256b_at_o32g2000yqm.googlegroups.com>
On Aug 11, 9:10 am, ca111026 <ca111..._at_gmail.com> wrote:
> Sorry, how buffer busy waits are related to ASSM?
Again:
You may have a look at the book by Tom Kyte : " Effective oracle By Design". He explains with statspack reports the impact of several oracle features. Page 232 - 234 are called : The Case for ASSM.
And yes, his example goes specificly about buffer busy waits. Received on Tue Aug 11 2009 - 04:06:05 CDT