Re: row cache lock contention parallel insert
From: Greg Rahn <greg_at_structureddata.org>
Date: Sun, 20 Dec 2009 09:00:32 -0800
Message-ID: <a9c093440912200900j510812e0t116670c3f16a570f_at_mail.gmail.com>
What does the ASH/AWR report show?
Date: Sun, 20 Dec 2009 09:00:32 -0800
Message-ID: <a9c093440912200900j510812e0t116670c3f16a570f_at_mail.gmail.com>
What does the ASH/AWR report show?
If you have initial extents of 10M for each segment and you are not allocating numerous additional extents, then its unlikely an extent allocation issue, correct?
On Sun, Dec 20, 2009 at 5:08 AM, LS Cheng <exriscer_at_gmail.com> wrote:
> Since my results are not consistent I am not really sure if the problem is
> caused by extent or segment space allocation.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 20 2009 - 11:00:32 CST